mysql query question
Posted: Mon Mar 24, 2003 7:16 am
these two queries work in mssql and doesnt in mysql any ideas?
and this also deosnt work:
thanks
Guy
Code: Select all
select count(*) as count from table1 where field1 in(select ID from table2 where field2 = 'Value1')Code: Select all
select count(*) as count from table1 where field1 = (select ID from table2 where field2 = 'Value1')Guy