From jet to t-sql

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello

I've got a problem using a T-sql syntax.
The jet syntax goes:
SELECT 0,"<<Add new>>" FROM employees
UNION (SELECT DISTINCTROW employees.id,employees.lastname & ", " &
employees.firstname from employees);

Can someone tell me how it goes in T-SQL


thanks
steve

steve
 
-----
SELECT ID,lastname + ', ' + firstname
from employees
UNION
SELECT 0,'<<Add new>>'
 
Back
Top