« Has any one had Liposculpt by the Horizon Medical group in London?
MS Access Help? »

convert this sql qry to access qry?

select mname,id,name from item_mansup where sid= 488 and id in (select distinct itemid from item_tr where itemid not in(select distinct id from item_mansup where sid = 971)

this qry is not running in access any body help me ?

If this is the *exact* query, you’re missing a second closing ) after the second embedded select. Other than that, I don’t see anything wrong with it. Doing two nested INs might not be the most efficient way to do things, but without knowing your table design, I couldn’t recommend anything else.

This entry was posted on Sunday, December 6th, 2009 at 12:12 pm and is filed under select distinct. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “convert this sql qry to access qry?”

  1. If this is the *exact* query, you’re missing a second closing ) after the second embedded select. Other than that, I don’t see anything wrong with it. Doing two nested INs might not be the most efficient way to do things, but without knowing your table design, I couldn’t recommend anything else.
    References :

  2. The query is right but you forgot to place the closing brace in the last.

    Say…. sid = 971))
    References :

Leave a Reply