Fixed Column from one table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables; one with work orders and one a list of water main breaks.
I also created a table with just the date from January 1, 2000 to present
date.

I want a query that shows every date and takes data from each of the other
tables. I know the two tables are not "synchronized" and I need to fill in
blanks. For example I might have had a water main break on one day but no
one made a work order entry or vise-versa.

Note: there may be several breaks in one day!
 
Post your actual table structure - field names and data type.
Post examples of data in your tables.
 
Back
Top