David Hall-426383 (8/12/2014)

---

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 appl_no,

id,

(select f_name from person where person.id = testers.id) f_name,

(select l_name from person where person.id = testers.id) l_name,

approved,

credential,

broadening,

getdate() 'sent'

FROM testers

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...