> Ooooo. I've got a headache trying to understand joins. I'm definitely > NOT a database guru. > > Why in the world doesn't this work? > > > SELECT dacspriv_name > FROM dacspriv > WHERE dacspriv_id not in (SELECT dacspriv_id > FROM dacs_access JOIN users > ON dacs_access.user_id=users.user_id > WHERE users.username='sator') > > Susan Ator > Online Services Engineer > National Public Radio > Distribution Division > [EMAIL PROTECTED] Short answer is mysql does not do sub-selects (i.e., a select inside of a select). The join part is not this issue.
William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]