What are you trying to accomplish with the query? What results do you EXPECT to be returned?
Can you not do what you're trying to do with: SELECT id FROM Table WHERE (nr=3D123 AND nr=3D456) ? ----- Original Message ----- From: "Spielberg Micha" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 22, 2002 1:45 AM Subject: Subselect or other way? Hi, i have a table like this: Fields: id,nr I want now a query like this: SELECT id FROM Table WHERE nr=3D123 and (SELECT id FROM Table WHERE nr=3D456). Must i do this with a temp Table or ist there any other way to do this with Joins? I hope someone can help me.. regards Micha --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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