Hi everyone
Maybe somebody can help me with what seems like a tricky
subselect-avoidance question?
In a MySQL database, there are two tables - 'reports' and
'reports_signup'. 'reports' has two columns, 'id' and 'report_name'.
'reports_signup' has three columns - 'id', 'report_id' and 'user_id'.
('id' in this table may be superfluous). 'report_id' is a value from
the 'reports_table', and 'user_id' is a value from another table.
I've written a query to select the report names of all reports a
particular user (say, id '2') is signed up to:
SELECT reports.id,reports.report_name FROM reports LEFT JOIN
reports_signup ON reports.id = reports_signup.report_id WHERE
reports_signup.user_id = '2';
I now want to write a query to select the report names of all reports a
particular user is *not* signed up to - I'm having big troubles with this.
Can anybody assist me?
Best wishes,
Peter.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
