J
Jason Lepack
I have a query that I am using to return a list of jobs to be used as
the data source of a combo box in a local vb.net application.
job:
job_id, job_num, other insignificant columns
1, '12345-11', ...
2, '12346-22', ...
etc.
My query is this:
SELECT
job_id,
job_num
FROM
job
ORDER BY job_id
And returns:
1, '12345-11'
2, '12346-22'
Now, I would like to return this:
-1, 'New Job...'
1, '12345-11'
2, '12346-22'
Can I not use a Union Query for that?
I can use:
SELECT -1, 'New Job...'
but when I union it with the existing query I get:
"Query input must contain at least one table or query."
Any help including a better way of doing this would be much
appreciated.
Cheers,
Jason Lepack
the data source of a combo box in a local vb.net application.
job:
job_id, job_num, other insignificant columns
1, '12345-11', ...
2, '12346-22', ...
etc.
My query is this:
SELECT
job_id,
job_num
FROM
job
ORDER BY job_id
And returns:
1, '12345-11'
2, '12346-22'
Now, I would like to return this:
-1, 'New Job...'
1, '12345-11'
2, '12346-22'
Can I not use a Union Query for that?
I can use:
SELECT -1, 'New Job...'
but when I union it with the existing query I get:
"Query input must contain at least one table or query."
Any help including a better way of doing this would be much
appreciated.
Cheers,
Jason Lepack