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,444 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,939 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

VB6 ACCESS table union issue

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  
All times are GMT -4. The time now is 2:31 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC