MySQL query on 2 tables?

[Anon]

Hi,

I have 2 tables. I need to get data from some columns of both tables.

This what I did:

\"SELECT t1.id, t1.ref, t1.type, t2.address, t2.city FROM t1 JOIN t2 WHERE t1.ref= \'$something\' AND t1.office = t2.ref\"

Instead of returning 1 result, it returns as many rows as t2 long is. It should only return the rows with address and city info associated with the match on table t1!

What am I doing wrong here?

Thanks,
Raoul

[kenpty]

t1.ref
t1.xx
t1.yy

t2.ref
t2.zz
t2.jj

select t1.xx, t1.yy,t2.zz,t2.jj from t1,t2 where t1.ref = t2.ref and t1.xx = 'something'

[Anon]

try this:

SELECT * FROM table1,table2 WHERE table1.row_id = '$foo' AND table2.row_id = '$foo'

That should bring back one row depending on
what $foo is (e.g. a row that auto increments
in both tables.)

hope it helps.

[Anon]

the problem with that is that I can't define $foo

the search should first get all results from table 1 and then look in table 2 and find the associated address and city based on the value of office in all the result rows from table 1.

Raoul

[Anon]

thanks Ken, that worked!

Raoul