Well, I'm running 3.23.54 on Red Hat 7.3. Given this, how in the world do I
accomplish the following:
I have these tables:
dacspriv - with dacspriv_id,dacspriv_name,short_name
users - with user_id,username
dacs_access - with dacsaccess_id,dacspriv_id,user_id
I need to be able to return a list of dacspriv.short_name where user.user_id
IS NOT in dacs_access but ONLY for that user_id (I have over 1700 users with
multiple mappings in dacs_access).
susan
-----Original Message-----
From: Ryan McDougall [mailto:[EMAIL PROTECTED]
Sent: Friday, May 30, 2003 12:11 PM
To: mysql
Subject: Re: Join problem
> Short answer is mysql does not do sub-selects (i.e., a select inside of a
> select). The join part is not this issue.
Wouldn't this depend on the version... I thought the newest versions, 4.x+,
supported sub-selects.
Ryan
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
