![]() |
#3 |
Участник
|
в догонку пример: главный датасет
select PL.ItemId, PL.InventDimId from PurchLine as PL join InventDim as IDim on IDim.InventDimId = PL.InventDimId and (IDim.inventlocationid = @inventlocationid) or (@inventlocationid = '***')) ------ дочерний select IL.inventlocationid, IL.name from inventlocation as IL where IL.shopGroupId = 'Маг. Опта' union select '***', 'Все магазины' |
|
|
|