Re: $ Access-SQL $ Retrieve records not matching the criteria

[Vikas Chauhan]

No,

without sub query it is not possible .  

---

Warm Regards,
VikaS CHAUHAN
9911868518
vika...@gmail.com,

On Fri, Jun 26, 2015 at 2:56 PM, B.Manivannan Cibi <cib...@gmail.com> wrote:

This message is eligible for Automatic Cleanup! (cib...@gmail.com) Add cleanup rule | More info

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? 

--
--
Forum Rules:
1) Use concise, accurate thread titles. Don't use Poor thread titles, like Please Help, Urgent, Need Help, Query Problem, Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Acknowledge the responses you receive, good or bad.
4) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
NOTE : Don't ever share your personal and confidential data . Forum owners and members are not responsible for any loss.
 
Group Email ID : acces...@googlegroups.com
Send Mail to Unsubscribe : access-sql+...@googlegroups.com
More Details about Group : http://groups.google.com/group/access-sql?hl=en

---
You received this message because you are subscribed to the Google Groups "Access-Sql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to access-sql+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.