Retunerer fire poster.. burde kun retunere en.
Retunerer fire poster.. burde kun retunere en.Hvad har jeg gjort forkert i følgende kode?
SELECT *
FROM inventtable
INNER JOIN pricedisctable ON
( pricedisctable.itemrelation = inventtable.itemid
AND pricedisctable.todate = '1900-01-01' )
INNER JOIN custvendexternalitem ON
( custvendexternalitem.itemid = inventtable.itemid )
WHERE
pricedisctable.todate = '1900-01-01'
AND custvendexternalitem.custvendrelation = '44948700'
AND pricedisctable.accountrelation = custvendexternalitem.custvendrelation
AND inventtable.primaryvendorid = ' 44948700'
AND inventtable.itemid = '048-1476318'
ORDER BY inventtable.primaryvendorid
På forhånd tak!