Select
field1,
(select top 1 field1 from table2
where id = table1.id) myfield
from table1
This works in SQL Server but not in Sybase.
This is as of Sybase ASE 12.5, I don't know if this changed in Sybase ASE 15, so, if you have any idea bout it please share this with us in the comments section.
0 comments:
Post a Comment