Newbies piping Posted February 9, 2010 Newbies Share Posted February 9, 2010 Hello! I have two tables that have the same structure, one for current jobs and the other for closed jobs (do not ask me, that is what it was and they do not want to change it). They are mutually exclusive. I need to pull data from both tables, with the exactly same criteria for a report, but I do not know how to combine them, so the result can be all records matching the criteria from both tables. Any suggestions? Link to comment Share on other sites More sharing options...
bcooney Posted February 9, 2010 Share Posted February 9, 2010 I've moved your post to Printing. We really should have a subforum for Data Modeling. This is a perfect example of poor data modeling, sorry. It's always at the reporting stage that you realize that all you really needed was one field in jobs that distinguished the status. I sympathize with the mess you've inherited. I can only imagine. Well, what you could do is create a table for reporting and import from each of the other tables a found set of records. Or, move the closed jobs back into the jobs table and add a status field. Then, report away. (work with a backup bcs you're changing many records at once!) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5212 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now