User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 423,566 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 3,641 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 Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 405 | Replies: 2
Join Date: May 2008
Posts: 1
Reputation: dominiopt is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
dominiopt dominiopt is offline Offline
Newbie Poster

VB6 ACCESS table union issue

  #1  
May 12th, 2008
Hi list,

After creating a rs with UNION ALL two tables it's possible know record by
record the original table source (using any extra SQL feature or something
else)

SQL = "SELECT * FROM tabA UNION ALL SELECT * FROM tabB ORDER BY field"
Set rs = db.OpenRecordset(SQL)

Thanks
Fernando
AddThis Social Bookmark Button
Reply With Quote  

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Other Threads in the Visual Basic 4 / 5 / 6 Forum

All times are GMT -4. The time now is 6:46 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC