MySql subquery

[louie]

I have two tables that are not related in any way because it can not be....

I want to select all the records from the first table but only if a certain field in the second table = 'yes'

Any ideas? I am at it for the last half an hour and can't seem to get any results.

 

[ziycon]

Try something like the below, works grand for myself on two separate tables. This will return everything from table 1.

SELECT * FROM tbl1, tbl2 WHERE IF(tbl2.col='value','yes','no')='yes';

 

[louie]

Tried that already but not luck.
I get : "Impossible WHERE noticed after reading const tables" from Mysql DB

 

[ziycon]

That message is saying that while the where clause is valid an empty result set was returned, are you sure the IF statement is pointing to a valid table/column?

 

[louie]

Yes it is.

 

[ziycon]

Can you throw in 'EXPLAIN' or 'EXPLAIN EXTENDED' in front of the query to get more information from the optimiser?