RE: query help

there is no USER_DOCS record for a given USER and DOC record (FULL OUTER JOIN)? On Sat, Mar 8, 2008 at 12:12 AM, Josh McKinley [EMAIL PROTECTED] wrote: - Excess quoted text cut - see Original Post for more - ~| Adobe

re: query help

I'm really looking for a solution with only one query using joins. It should be possible to do this with a couple of joins. This query, suggested by Steve, would work well if the tables remained small: SELECT user_id,user_name,doc_id,doc_name FROM USERS,DOCS WHERE NOT EXISTS ( SELECT

Re: query help

OK, so let's just say that the where not exists option is comparable in efficiency. I ran the query and was greeted by every row in the tables. 70K results instead of the 60 or so I should be getting. ~| Adobe® ColdFusion® 8

query help

I've got three tables like this (simplified): USERS user_id user_name DOCS doc_id doc_name USER_DOCS signoff_id user_id doc_id I need all user names and doc names where the combination doesn't exist in the signoff table USER_DOCS. For example, user 12 hasn't signed of on doc 9 and user 6

Re: query help

By the way, this is a MySQL DB. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: