I am migrating a Sybase ASE installation to SQL 2008R2, and have a query that runs on the Sybase, but not SQL. Can anyone tell me how to do this in SQL:
(select f_name from person where person.id = testers.id) f_name,
(select l_name from person where person.id = testers.id) l_name,
If I run this on SQL, it returns the 'Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.' error, and I understand why. On Sybase, it runs fine.
So..how will this need to be constructed to run on SQL?
Thanks in advance...