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