Please send
comments/questions to
michael@
teratech.com
Previous implementation
Previous implementation – UNION/JOIN query in Access
Query is messy:
query for each column name
query for extra rows in each of the 2 tables
extra predicates for nulls
extra predicates to flag duplicate rows
(should table not have a primary key)
Access permits union across dissimilar columns (different data types)
Access DOES permit inner join and union across linked tables from different DBMS, but I have not tested this.
Previous slide
Next slide
Back to first slide
View graphic version
Home
|
Links
|
Articles
|
Past Meetings
|
Meeting Photos
|
Site Map
About MDCFUG
|
Join
|
Mailing List
|
Forums
|
Directions
|
Suggestions
|
Quotes
|
Newbie Tips
TOP
Copyright © 1997-2024, Maryland Cold Fusion User Group. All rights reserved.
< >