Question about Union queries

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

Guest

I would like to make a list or combo box based off a table, with the addition
of a single line that doen't exist in any table.

What I'm trying:

SELECT [DeptNo], [DeptName] FROM tDepartments
UNION SELECT "*" AS [DeptNo], "All Deptarments" as [DeptName];

Obviously, this isn't working because there is no FROM clause in the union.
Is there a way to accomplish this?

Thanks in advance,
John
 
Back
Top