I'll take a whack at it.
You'll need a version that supports subqueries for this one:
SELECT * FROM applications WHERE appid != (SELECT appid FROM rejected)
ORDER BY appid DESC;
There's probably a way to do that with a join, too... and it would
probably be faster, but JOINs make my head hurt. :)
-Jeromie
>04232005 1707 GMT-6
>
>I need to do something like this:
>$sql = "SELECT * FROM application WHERE appid != rejected.appid ORDER BY appid
>DESC";
>
>I want to select all from application where the appid is not located in
>the table rejected. Im having trouble getting this to work. Can somebody
>help me here?
>
>Wade
>
The PHP_mySQL group is dedicated to learn more about the PHP_mySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
