Comments
Sort by recent activity
Aaron, I've corrected my sql to make it clearer
select *
from dbo.table1 as t1
where skey in (select top 1 t2.skey from dbo.table2 as t2 )
The qualify object names command is balking at the unqualified outer query.
In this case, the skey has to be from t1, right? So, my question is why does it balk?
Ephraim / comments
Aaron, I've corrected my sql to make it clearer
select *
from dbo.table1 as t1
where skey in (select top 1 t2.skey from dbo.table2 as t2 )
The qualify object names command is balking at the unquali...
yes, fixed, thanks ephraim / comments
yes, fixed, thanks ephraim
This fails qualify object names..
select *
from table1 as r
where skey in (select top 1 skey from dbo.table2) / comments
This fails qualify object names..
select *
from table1 as r
where skey in (select top 1 skey from dbo.table2)