Can somebody give me an SQL which will return all items which currently have no supplier assigned at all?
Thanks!
- posted
16 years ago
Basic SQL
Loading thread data ...
- Vote on answer
- posted
16 years ago
-- This is to get items that have no records in the supplier tab.
select itemlookupcode,description
from item left join supplierlist
on item.id=itemid
where itemid is null
order by Itemlookupcode
/* To get items that does not have supplier
Select itemlookupcode,description
Fron Item
Where Supplierid=0 */
"Philip Gass - Creative Gardens -" wrote in message news:% snipped-for-privacy@TK2MSFTNGP04.phx.gbl...
- Vote on answer
- posted
16 years ago
Select * From Item Where SupplierID = 0
"Philip Gass - Creative Gardens -" wrote in message news:% snipped-for-privacy@TK2MSFTNGP04.phx.gbl...
- Vote on answer
- posted
16 years ago
That assumes that all supplier & item edits have been done through the RMS UI (and that nothing has gone wrong anyway). The left join between Item and SupplierList is a better choice.
Glenn Adams Tiber Creek C> Select * From Item Where SupplierID = 0