Hi, I try it and I get a syntax error: "You have an error in your SQL syntax near 'on tbl2.A=tbl1.A where tbl2.A='a1'' at line 1" My tables structure are: show fields from QB; +----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | ref | char(3) | YES | | NULL | | | question | varchar(30) | YES | | NULL | | +----------+-------------+------+-----+---------+----------------+ show fields from relAB; +-------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | A | char(3) | YES | | NULL | | | B | char(3) | YES | | NULL | | +-------+---------+------+-----+---------+----------------+
Thanks for your help, Nuno Teixeira On Sat, Feb 09, 2002 at 08:49:44AM -0500, Butch Bean wrote: | I don't know you table structure but something like this would do it... | | SELECT * from QB as tbl1 | JOIN relAB as tbl2 | ON tbl2.A=tbl1.A | where tbl2.a='a1' | | Butch Bean | | -----Original Message----- | From: Egor Egorov [mailto:[EMAIL PROTECTED]] | Sent: Saturday, February 09, 2002 7:24 AM | To: [EMAIL PROTECTED] | Subject: is possible 1 query with 2 selects? | | | Nuno, | | Friday, February 08, 2002, 11:04:51 PM, you wrote: | | | NT> Hello to all, | | NT> I'm trying to make a query with only one command but I can't see how | to do | NT> it. | | [skip] | | NT> What I want to do is get a list from table QB related to an item from | NT> table QA: | | NT> For example, get a list from QB related to item 'a1': | | NT> 1. select B from relAB where A='a1'; | | NT> (result: b2, b3, b4) | | NT> 2. select * from QB where ref in ('b2','b3','b4'); | | NT> (result: only 'a1' related items) | | NT> There is a way of make this query with only one command? | | NT> Something like: | | NT> 1. select * from QB where ref in (select B from relAB where | A='a1'); | | MySQL doesn't curently support sub-selects, look at: | http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html | | It is in our plans to support sub-selects in future: | http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html | | NT> Please help me in this matter. | NT> Thanks very much, | | | | | | -- | For technical support contracts, goto https://order.mysql.com/ | This email is sponsored by Ensita.net http://www.ensita.net/ | __ ___ ___ ____ __ | / |/ /_ __/ __/ __ \/ / Egor Egorov | / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] | /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net | <___/ www.mysql.com | | | | --------------------------------------------------------------------- | 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 | -- Nuno Teixeira pt-quorum.com /* PGP Public Key: http://www.pt-quorum.com/pgp/nunoteixeira.asc Key fingerprint: 8C2C B364 D4DC 0C92 56F5 CE6F 8F07 720A 63A0 4FC7 */ --------------------------------------------------------------------- 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