back to QA. I find it easier to
|'visualise', but then other people
| aren't (quite) this crazy!
|
| Regards,
| =dn
Hi,
Ok. I start understand this better and what I need is working very well now.
I think I've posted this doubt because I made some confusion about
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='a
7;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.
| Null | Key | Default | Extra |
+---+-+--+-+-++
| id| int(11) | | PRI | NULL| auto_increment |
| A | char(3) | YES | | NULL||
| B | char(3) | YES | | NULL||
+---+-+--+-+-++
Thanks for
(result: only 'a1' related items)
There is a way of make this query with only one command?
Something like:
1. select * from QB where ref in (select B from relAB where A='a1');
Please help me in this matter.
Thanks very much,
-
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='a
7;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.
| Null | Key | Default | Extra |
+---+-+--+-+-++
| id| int(11) | | PRI | NULL| auto_increment |
| A | char(3) | YES | | NULL||
| B | char(3) | YES | | NULL||
+---+-+--+-+-++
Thanks for
(result: only 'a1' related items)
There is a way of make this query with only one command?
Something like:
1. select * from QB where ref in (select B from relAB where A='a1');
Please help me in this matter.
Thanks very much,
-
