information from two tables

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

Guest

Hi, I have two tables one shows our UPS billings and another for our freight
billings. I need to have a query by job number that shows all our billings on
a certain date. My issue is that you may have just a freight billing, just
UPS billing or both. None of the joins right, left, or inner pick up all the
information I need.

Example of tables

Freight UPS

date billed date billed
job number job number
billed amount billed amount

Help if you can!

Thanks
Jeanne
 
Maybe you could have just one table with 4 columns:

billing type
date billed
job number
billed amount
 
Or you could try using a union query.
-----Original Message-----
Maybe you could have just one table with 4 columns:

billing type
date billed
job number
billed amount

shows
all our billings on
.
Click to expand...
 
Yes, I did this using Union All I found on another question.
The tables feed a lot of other information so I could not put them into one
table.

Thanks for you help
 
Back
Top