Hi all

SQL is without a doubt my downfall, and I'm not gettin any younger, or
smarter in that stable either...

That Said....!!!!!

Can anyone help with the following plz.....

(This works fine)
SELECT [txtMainActor] AS [Actors] FROM tblDVDList
UNION SELECT [txtOtherActor] FROM tblDVDList;

(This on the other-hand, does not)
SELECT [txtMainActor] AS [Actors] FROM tblDVDList, [txtGender] AS [Gender]
FROM tblDVDList
UNION SELECT [txtOtherActor] AS [Actors] FROM tblDVDList, [txtGender] AS
[Gender] FROM tblDVDList;

(I get a SYNTAX error in FROM)

Essentially, I would like to include the gender of each in the UNION if at
all possible...

TIA

On 16 aug, 09:00, "NoodNutt" <mcli... (AT) bigpond (DOT) com> wrote:
A query to select two fields should look like:
SELECT [txtMainActor] AS [Actors], [txtGender] AS [Gender] FROM
tblDVDList

Groeten,

Peter
http://access.xps350.com

NoodNutt wrote:
(source)

SELECT [FldName1] AS Colname1, [FldName2] AS Colname2 FROM TableName;

Check out help for the difference between UNION and UNION ALL. Or
experiment by adding the word All after Union.

IF you have multiple columns and you want to sort the result set it
probably easier to have a line like
Order By 3,2,1
and that will sort by the third, second, and first column. The OrderBy
goes on the last Select in the union query.

On 16/08/2010 08:00:31, "NoodNutt" wrote:
Like you, well past it (well you may not be)

If you really want a Union Query, and I don't think you do here, I normally
create 1 standard query using the query design tool for each table (or
query). Add any aliases - like AS Actors, but don't bother with the sort by.
Make sure that there are the same number of output fields and that they have
the same name, are in the same order. If using say 2 tables for your Union
query, copy the SQL version of the second query into the SQL of the first
query, adding the word UNION or UNION ALL just in fronnt of the bit you paste
in. Don't forget to remove the first ";" at the end of the first part of the
SQL. You can then add if you want SORT BY clause. Again ensure there is only
1 ";" at the end

Phil

Thx heaps to each of you

appreciate your assist.

Cheers