simple union query

  • Thread starter Thread starter aaron.kempf
  • Start date Start date
A

aaron.kempf

team

i've been trying to get this simple union query to work; and i've had
this problem twice in the past month

why doesn't this work:

-=----------------------------

SELECT 'Board Administration' AS DEPARTMENT
UNION
SELECT 'Capital Projects'
UNION
SELECT 'Executive'
UNION
SELECT 'Finance & Information Technology'
UNION
SELECT 'Legal'
UNION
SELECT 'Link Light Rail'
UNION
SELECT 'Project Delivery'
UNION
SELECT 'Transportation Services'

-------------------------------

it gives me the error 'query input must contain at least one table or
query'

I dont agree with this message; there isnt' a reason in hell that i
can't do this.

it's just a bug.

and i want to know why it isn't fixed.

-Aaron
 
team

i've been trying to get this simple union query to work; and i've had
this problem twice in the past month

why doesn't this work:

-=----------------------------

SELECT 'Board Administration' AS DEPARTMENT
UNION
SELECT 'Capital Projects'
UNION
SELECT 'Executive'
UNION
SELECT 'Finance & Information Technology'
UNION
SELECT 'Legal'
UNION
SELECT 'Link Light Rail'
UNION
SELECT 'Project Delivery'
UNION
SELECT 'Transportation Services'

-------------------------------

it gives me the error 'query input must contain at least one table or
query'

I dont agree with this message; there isnt' a reason in hell that i
can't do this.

it's just a bug.

and i want to know why it isn't fixed.
Click to expand...

Are you running this query in Jet? If so, it's not a bug. JET SQL
syntax for a SELECT statement requires a FROM clause. T-SQL sntax does
not.
 
dirk

what are you talking about it's not a bug?

it's a pain in the ass-- why wouldn't it be a bug? i mean-- an
unnecessary DIFFERENCE where something doesn't work in Access that does
work in SQL?

that sounds like a bug

i know exactly what im missing-- i dont want to use a table. tsql
doesn't make me use a table; why wouldn't Access act the same way?

i just dont know how they indiscriminitely come up with 'oh its not a
bug' i mean jesus ****ing christ why are they inconsistent?
 
Back
Top