Need help

Oct 29 2013 12:45 AM

I have a table contain data like

PicklistNo Status

PKL019000 LOD

PKL019000 WIP

If any status contain Wip it give no result.

I used query :-

Select DISTINCT PickListNo,status from tablename WHERE PickListNo='PKL019000' and Status='LOD'

It gives me result. But I dont want any row if any row status contain WIP

Answers (5)

SQL Suery to join Two table

compare two tables select not matching coloum in table b