I've got a MySQL query that I'm not sure why it isn't working. I've got two tables with the same fields (the entries are based on gender) and I thought that this query would work properly but I guess not:

SELECT t1.*, t2.* FROM t1, t2 WHERE (t1.cat = 'value' AND t1.status = 'active') OR (t2.cat = 'value' AND t2.status = 'active')

Since the fields are the same between the tables, I resolve the WHILE loop with a mysql_fetch_array that just calls for the fields that should be coming up regardless of table name. I'm a little short on knowledge when it comes to joins I'm guessing there's a better way to do it than this because right now whichever table is called first isn't even showing up in the results.

Thanks

edit - syntax mistake

[edited by: Murdoch at 5:03 pm (utc) on July 14, 2008]