Join to tables in mySQL??

[slyfox]

Hi again friends

I need to join two tables, here are the details:

select * from t_one where abc = 0 and xyz = 0
and
select * from t_two where id = t_one.id
Something in that line...

basically i'm reading many fields from one table and i just need a value from the name field in the second table where the id in the second table matches the id in the first table..

Any help please, and i cannot do it any other way than joining the 2 tables... i saw a joining query buntine wrote for another post, but when i implemented it to work on my database, it gave an error and i dunno how to fix it...

here is the post i got from buntine some time ago:
sql_query = "SELECT * FROM table_one INNER JOIN table_two ON first_table.idOrder = second_table.idOrder"

So please, if anyone can help me!!:p

[buntine]

try this


sql_query = "SELECT * FROM t_one WHERE abc=0 and xyz=0 INNER JOIN t_two ON t_one.idOrder = t_two.idOrder

[olaf]

Hallo,

It looks more like a case for a "left join statement".

If Slyfox's suggestion doesn't work post your table structures and discribe which data you exactly want to query.