•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 422,391 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,834 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 626 | Replies: 3 | Solved
 |
| |
•
•
Join Date: Sep 2007
Posts: 13
Reputation: 
Rep Power: 2
Solved Threads: 0
Newbie Poster
hi all,
Table 1:
ID | COL1
1 | 1
1 | 13
1 | 64
Table 2:
ID | COL1
1 | 14
1 | 13
Output needed:
ID | COl
1 | 1
1 | 13
1 | 14
1 | 64
How will i accomplish this???
Thanks and regards
Bhakti
Table 1:
ID | COL1
1 | 1
1 | 13
1 | 64
Table 2:
ID | COL1
1 | 14
1 | 13
Output needed:
ID | COl
1 | 1
1 | 13
1 | 14
1 | 64
How will i accomplish this???
Thanks and regards
Bhakti
•
•
Join Date: Nov 2007
Location: � Jogja �
Posts: 2,584
Reputation: 
Rep Power: 11
Solved Threads: 235
MSSQL Syntax (Toggle Plain Text)
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
•
•
Join Date: Mar 2008
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
hi, you need to use union
SELECT ID, COL1 FROM Table1
UNION
SELECT ID, COL1 FROM Table2
SELECT ID, COL1 FROM Table1
UNION
SELECT ID, COL1 FROM Table2
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Hybrid Mode
Similar Threads
- Is Stormpay a credible payment system? (eCommerce)
- 8th BME International 24-hour Programming Contest! (Software Developers' Lounge)
- average stats (Growing an Online Community)
- Senior Developer (Software Development Job Offers)
- SQL Server DBA (Software Development Job Offers)
- Would someone please explain what folding means? (Geeks' Lounge)
Other Threads in the MS SQL Forum
- Previous Thread: How to import Excel Sheet data into SQL Server 2003 ???? Stpes.
- Next Thread: Errors installing a database from a backup
