Hi,
I need to get stock information from parts.
I can query two of the tables, but need to get two other stock sums from a third table.
SELECT ac.saext AS Satzart
,ac.raint AS SatzarKZ
, ac.MNR AS Teilenummer
, ac.KTXT AS Beschreibung
, acd.mindbestand AS Mindestbestand
, acd.sichbestand AS Sicherheitsbestand
, ac.wbz
, SELECT Sum(E_STATICQUANTITY) FROM relwmsstocksum StS
WHERE itemno in (ac.mnr)
FROM relac ac
inner join Relacd acd ON ac.mnr = acd.mnr
Inner Join relwmsstocksum StS
My problem ist getting the sum information from the table relwmsstocksum StS
The Table RELAC is linked with the table relwmsstocksum by: MNR = ITEMNO.
Whats wrong in my Query??