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
Moderator: General Moderators
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')