Why does this query work, but not the other example?

[Guest]

Can someone explain why the 1st query works, but the second doesn't?

SELECT [Run_Point_Venue_A], [Run_Point_Address_A] FROM [Run_Points]
UNION SELECT [Run_Point_Venue_C], [Run_Point_Address_C]
FROM [Run_Points]

SELECT [Run_Point_Venue_A], [Run_Point_Address_A] FROM [Run_Points]
SELECT [Run_Point_Venue_B], [Run_Point_Address_B] FROM [Run_Points]
UNION SELECT [Run_Point_Venue_C], [Run_Point_Address_C]
FROM [Run_Points]





SELECT [Run_Point_Venue_C], [Run_Point_Address_C] FROM [Run_Points]

 

[Guest]

Because you forgot a UNION statment between the 1st and 2nd SELECT statements.

 

[Guest]

Thanks Dale, I can get my head around the theory, but it's the syntax that is
usually my undoing... do you know a good online source for syntax in queries
with examples?

Because you forgot a UNION statment between the 1st and 2nd SELECT statements.


--
Email address is not valid.
Please reply to newsgroup only.

Can someone explain why the 1st query works, but the second doesn't?

SELECT [Run_Point_Venue_A], [Run_Point_Address_A] FROM [Run_Points]
UNION SELECT [Run_Point_Venue_C], [Run_Point_Address_C]
FROM [Run_Points]

SELECT [Run_Point_Venue_A], [Run_Point_Address_A] FROM [Run_Points]
SELECT [Run_Point_Venue_B], [Run_Point_Address_B] FROM [Run_Points]
UNION SELECT [Run_Point_Venue_C], [Run_Point_Address_C]
FROM [Run_Points]





SELECT [Run_Point_Venue_C], [Run_Point_Address_C] FROM [Run_Points]

 

[jinsungy]

try http://www.w3schools.com/sql/default.asp

Thanks,
www.dbwiz.com