Retrieve records not matching the criteria

1 view
Skip to first unread message

B.Manivannan Cibi

unread,
Jun 26, 2015, 5:26:57 AM6/26/15
to acces...@googlegroups.com
Hi,

I have a table like 










If any name matches Status Y and N, i have to omit the record. Remaining records i have to retrieve. How to achieve this?

Is it possible to do without subquery? 
Reply all
Reply to author
Forward
0 new messages