select x,y,z from view1 where x in ('abc')
select x,y,z from view1 where x in (select 'abc' from table1 where y='1234')
select x,y,z from view1 where x in (select x from table1 where y='1234')
JOIN
IN
select x,y,z from view1 inner join table1 on ((view1.x = table1.x) and (table1.y='1234'))
select x,y,z from view1 WITH (Index(Index_x)) where x in (select x from table1 WITH (Index(Index_y)) where y='1234')
select x,y,z from view1 where exists (select * from table1 where y='1234' and table1.x=view1.x)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)