Cześć
Chciałem dopytać jak dodać wyświetlanie grup towarów dla zestawienia SQL
select [tw_Symbol] [Symbol]
,[tw_Nazwa] [Nazwa]
,[8].st_Stan [KA]
,[26].st_Stan [MT]
,[63].st_Stan [SO]
,[64].st_Stan [PSO]
,[70].st_Stan [RZ]
,[71].st_Stan [PSW]
,[72].st_Stan [ŁD]
,[73].st_Stan [JP]
,[74].st_Stan [PS5]
,[75].st_Stan [PS4]
,[76].st_Stan [GD]
,[80].st_Stan [LUB]
,[81].st_Stan [KIE]
,[8].st_Stan + [26].st_Stan + [63].st_Stan + [64].st_Stan + [70].st_Stan + [71].st_Stan + [72].st_Stan + [73].st_Stan + [74].st_Stan + [75].st_Stan + [76].st_Stan + [80].st_Stan + [81].st_Stan [Razem]
from tw__Towar
join tw_Stan [8] on tw_Id = [8].st_TowId and [8].st_MagId = 8
join tw_Stan [26] on tw_Id = [26].st_TowId and [26].st_MagId = 26
join tw_Stan [63] on tw_Id = [63].st_TowId and [63].st_MagId = 63
join tw_Stan [64] on tw_Id = [64].st_TowId and [64].st_MagId = 64
join tw_Stan [70] on tw_Id = [70].st_TowId and [70].st_MagId = 70
join tw_Stan [71] on tw_Id = [71].st_TowId and [71].st_MagId = 71
join tw_Stan [72] on tw_Id = [72].st_TowId and [72].st_MagId = 72
join tw_Stan [73] on tw_Id = [73].st_TowId and [73].st_MagId = 73
join tw_Stan [74] on tw_Id = [74].st_TowId and [74].st_MagId = 74
join tw_Stan [75] on tw_Id = [75].st_TowId and [75].st_MagId = 75
join tw_Stan [76] on tw_Id = [76].st_TowId and [76].st_MagId = 76
join tw_Stan [80] on tw_Id = [80].st_TowId and [80].st_MagId = 80
join tw_Stan [81] on tw_Id = [81].st_TowId and [81].st_MagId = 81
where tw_Usuniety = 0
and tw_Zablokowany = 0
Z góry dzięki za odpowiedź
