02 Jul 2004 @ 10:46 AM 

Does anyone know a lot of Access/SQL tricks? I manage the databases at work, but don’t have any particular training beyond hitting F1. Well, the installation I’m stuck with is not one I’d prefer, but it is what it is.

I have to maintain two databases with identical structures but different data. How can I make a query that will provide me a unified view of the data, in a third “front-end” database? I know it must be possible, but I can’t figure it out. The SQL JOIN command sounded like a good avenue of investigation, but doesn’t look right for this. I need to be able to create a fake append, more or less, without modifying the data in the tables themselves.

An example: I’ve got two tables with lesson data (when it was assigned, completed, etc.) but I want to output one report at the end of the month on what was accomplished by everyone. I know, I should just leave everything in one database instead of two. I don’t have a choice. I know, I should use something more powerful than MS Access. I don’t have a choice.

Any help would be appreciated.


*Update* I convinced them to go with a sane configuration, and we’ll be going to one database with an optional field.

Posted By: Gary
Last Edit: 02 Jul 2004 @ 04:35 PM

EmailPermalinkComments (0)
Tags
Categories: Geek

 Last 50 Posts
Change Theme...
  • Users » 3
  • Posts/Pages » 2,264
  • Comments » 895
Change Theme...
  • VoidVoid « Default
  • LifeLife
  • EarthEarth
  • WindWind
  • WaterWater
  • FireFire
  • LightLight

MythTV



    No Child Pages.

Who is Bunk?



    No Child Pages.