Link two tables using union

[imtmub]

Hi,
I have three tables its contains same kind of fields for different time periods. For the result i want to link the tables. can u tell me some examples.

[willakawill]

Hi,
I have three tables its contains same kind of fields for different time periods. For the result i want to link the tables. can u tell me some examples.

Hi. If you would kindly post the table structures here we could do business :)

[imtmub]

Hi. If you would kindly post the table structures here we could do business :)

My Table contains City, VenueId,VenueNa me, Industry, Address,DS,GW,M L, Total, Rn, FalioNo, Date, Status. ( All the three tables contains the same Field structure). Now i want make a link to get all the rows in one.

[willakawill]

My Table contains City, VenueId,VenueNa me, Industry, Address,DS,GW,M L, Total, Rn, FalioNo, Date, Status. ( All the three tables contains the same Field structure). Now i want make a link to get all the rows in one.

SELECT
City, VenueId,VenueName, Industry, Address,DS,GW,ML, Total, Rn, FalioNo, Date, Status
FROM TableA
UNION
SELECT
City, VenueId,VenueName, Industry, Address,DS,GW,ML, Total, Rn, FalioNo, Date, Status
FROM TableB
UNION
SELECT
City, VenueId,VenueName, Industry, Address,DS,GW,ML, Total, Rn, FalioNo, Date, Status
FROM TableB
ORDER BY 1
 
 

[imtmub]

SELECT
City, VenueId,VenueName, Industry, Address,DS,GW,ML, Total, Rn, FalioNo, Date, Status
FROM TableA
UNION
SELECT
City, VenueId,VenueName, Industry, Address,DS,GW,ML, Total, Rn, FalioNo, Date, Status
FROM TableB
UNION
SELECT
City, VenueId,VenueName, Industry, Address,DS,GW,ML, Total, Rn, FalioNo, Date, Status
FROM TableB
ORDER BY 1
 
 

I m getting error when i m saving the view in sql. It showing the Error like "The Query Designer does not support the UNION SQL construct" I m using Sql Server2000.

[willakawill]

I m getting error when i m saving the view in sql. It showing the Error like "The Query Designer does not support the UNION SQL construct" I m using Sql Server2000.

Use the query analyser instead

[imtmub]

Use the query analyser instead

In the Query Analyser its showing the result. Bu tin the Enterprise manager when i m trying to save the query its showing that "View Definition includes no output columns or includes no items in the FORM Clause"

Here my Code
SELECT *
FROM November
UNION ALL
SELECT *
FROM October;
First i m trying only two tables and its contains the same fields but time period is different. In the query analyser its giving result.

[willakawill]

In the Query Analyser its showing the result. Bu tin the Enterprise manager when i m trying to save the query its showing that "View Definition includes no output columns or includes no items in the FORM Clause"

Here my Code
SELECT *
FROM November
UNION ALL
SELECT *
FROM October;
First i m trying only two tables and its contains the same fields but time period is different. In the query analyser its giving result.

The enterprise manager does not recognise UNION. You can't use it for such a query.

[imtmub]

The enterprise manager does not recognise UNION. You can't use it for such a query.

So how to link two tables in query.

[willakawill]

So how to link two tables in query.

The enterprise manager is not something that you would normally use for day to day processes. Design and analysis maybe.

SQL Sever recognises the UNION structure so you either run your query as a stored procedure or from another app such as vb or Access.