Show only in progress records without the finished records

Martin James

4y1.4k

I have the following table Product :

ProductID |ClientID |Status
--|--|--
100 |12 |Available
100 |13 |In process

100 |14 |Not yet

I want to get only the products with only with Not Yet status
and not other ones

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Accepted answer

SELECT * FROM ProductTable

 AS A WHERE NOT EXISTS

 (   SELECT * FROM ProductTable
 AS B   WHERE A.ProductID=B.ProductID
ID   AND Status NOT LIKE 'Not yet'         )

Muhammad Imran Ansari4y ago
This can also be achieve through a simple query like:
SELECT * FROM Products WHERE [Status] <> 'Not Yet'
0