home Links Articles Books Past Meetings Photos SiteMap
The MDCFUG is sponsored by TeraTech. Visit us at www.TeraTech.com

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-2017, Maryland Cold Fusion User Group. All rights reserved.
< >