Re: help w/ query

On 19 Oct 2001 at 19:32, G.L. Grobe wrote:

> Anyone help w/ the following sql query ... Here's my tables
...
>
> table A
> id name
> -----|-------
> 1000 AA
> 1001 AB
> 1002 AC
> 1003 AD
>
> table B
> id pid
> -----|-------
> 1000 1000
> 1001 1000
> 1002 1000
> 1003 1001
> 1004 1001
>
> Here's my query, (note that 'AA' is all the info I provide,
> cause that's the ) ...
>
> SELECT B.id FROM B, A WHERE B.pid = A.id AND A.name = 'AA';

I think you misspelled the first parameter of the first
WHERE condition. It should be "B.id", not "B.pid":

SELECT B.id FROM B, A WHERE B.id = A.id AND A.name = 'AA';

--
Ernesto Baschny <ernst(at)baschny(dot)de>
http://www.baschny.de - PGP Key:
http://www.baschny.de/pgp.txt
Sao Paulo/Brasil - Stuttgart/Germany
Ernst(at)IRCnet - ICQ# 2955403