Hi, It works! Thanks very much for your great help. I'm a newbie in SQL and I'll study more your examples. Thanks again, Nuno Teixeira On Sat, Feb 09, 2002 at 07:52:15PM -0500, Butch Bean wrote: | I changed it... | they were | AND relAB.B='a1' in the other examples | | | | SELECT QB.id, QB.ref, QB.question from QB, relAB | | WHERE QB.ref=relAB.B | | AND relAB.A='a1' | | | | SELECT DISTINCT QB.id, QB.ref, QB.question from QB, relAB | | WHERE QB.ref=relAB.B | | AND relAB.A='a1' | | | | SELECT * from QB as tbl1 | | LEFT JOIN relAB as tbl2 | | ON tbl2.B=tbl1.ref | | where tbl2.A='a1' | | -----Original Message----- | From: Nuno Teixeira [mailto:[EMAIL PROTECTED]] | Sent: Saturday, February 09, 2002 12:45 PM | To: Butch Bean | Cc: [EMAIL PROTECTED] | Subject: Re: is possible 1 query with 2 selects? | | | | Hi, | | Ok. Now I don't get syntax error but I don't get any results. | | Anyway, I think that it is something like your examples. | | Again, I need to get this results with only one query: | | 1st: get results from relAB to see QB relations: | | SELECT B from relAB WHERE A='a1'; | | results: | +------+ | | B | | +------+ | | b1 | | | b2 | | | b3 | | +------+ | | (This results said that only QB b1, b2 and b3 refs are related to 'a1') | | 2nd: get only b1, b2, b3 from QB: | | SELECT * FROM QB WHERE ref in ('b1','b2','b3'); | | results: | +----+------+----------+ | | id | ref | question | | +----+------+----------+ | | 1 | b1 | qb1 | | | 2 | b2 | qb2 | | | 3 | b3 | qb3 | | +----+------+----------+ | | | I'm trying to adapt your examples to see if I can get it to work. | | Thanks again, | | Nuno Teixeira | | | On Sat, Feb 09, 2002 at 12:16:40PM -0500, Butch Bean wrote: | | Nuno, | | | | I think these examples will work OK for what you want... | | | | Butch | | | | SELECT QB.id, QB.ref, QB.question from QB, relAB | | WHERE QB.ref=relAB.B | | AND relAB.B='a1' | | | | SELECT DISTINCT QB.id, QB.ref, QB.question from QB, relAB | | WHERE QB.ref=relAB.B | | AND relAB.B='a1' | | | | SELECT * from QB as tbl1 | | LEFT JOIN relAB as tbl2 | | ON tbl2.B=tbl1.ref | | where tbl2.B='a1' | | | | | | -----Original Message----- | | From: Nuno Teixeira [mailto:[EMAIL PROTECTED]] | | Sent: Saturday, February 09, 2002 11:18 AM | | To: Butch Bean | | Cc: [EMAIL PROTECTED] | | Subject: Re: is possible 1 query with 2 selects? | | | | | | | | 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 | | | | | | -- | 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 | */ |
-- 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
