In your query ID2 cannot be both 1 and 2 (typomundo) Peter <^_^>
-----Original Message----- From: James Dyer [mailto:jad@;disparate.org] Sent: Monday, November 11, 2002 3:04 PM To: [EMAIL PROTECTED] Subject: Problems with simple(?) query Hi, I'm trying to write what I am sure should be a simple query, but just can't get it to work! If I create a table called foo like this: create table foo ( id1 int(11) , id2(int 11) ); populate it with data and then try: SELECT * FROM foo WHERE id2=1 AND id2=2 (for example), I just get an empty set returned. An explain on the query gives an 'Impossible WHERE' message. Both id1 and id2 can have duplicate values in them, though the same combination of id1 and id2 cannot appear in the data (ie: id1=1, id2=1 ; id1=1, id2=2 is possible, id1=1, id2=1 ; id1=1, id2=1 is not possible), and it is possible that the values I search for will not be in the table at all. All I really want is to get the value for id1 where there are corresponding records which match all of my search parameters for id2. Anyone got any ideas how to manage this? It's beginning to drive me mad! Thanks, James --------------------------------------------------------------------- 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
