A
Angela
Hello,
I have two tables.
Table1:
Date/Time Number Product
12/03/2009 7870055 PLANA
12/05/2009 7870055 PLANA
Table2:
Date/Time Number Product
14/04/2009 7870055 Done
Well as one can see, the number is common in both tables.
I would like to return a query with following result.
Result:
Date/Time Number Product
12/05/2009 7870055 PLANA
My guess is the date column has to play an important role here but
how, that is confusing.
Thanks.
I have two tables.
Table1:
Date/Time Number Product
12/03/2009 7870055 PLANA
12/05/2009 7870055 PLANA
Table2:
Date/Time Number Product
14/04/2009 7870055 Done
Well as one can see, the number is common in both tables.
I would like to return a query with following result.
Result:
Date/Time Number Product
12/05/2009 7870055 PLANA
My guess is the date column has to play an important role here but
how, that is confusing.
Thanks.