i got one for you

i have two tables in a data base.
the first one is called inspections it consits of

col1 Well_name vchar
col2 Date shortdate
col3 level numeric
grouped by well name and date is desc
second table is called delivery it consits of

col1 well_name vchar
col2 date shortdate
col3 amount numeric

what i need...