Hi there

I have 2 SQL tables
the first one shows the order date....and the second one shows the date that the order was completed

Table1
-------
Order Code - Order Date

001 - 10/10/2009
002 - 11/10/2009
003 - 11/10/2009
004 - 12/10/2009
005 - 14/11/2009

Table2
-------
Order Code - Order Completed

002 - 11/11/2009
003 - 15/12/2009
005 - 16/12/2009


the thing i wanna do is a SELECT query that shows the following ...

Order Code - Order Date - Order Completed - Status(Constant Value)
001 - 10/10/2009 - NULL - ON GOING
002 - 11/10/2009 - 11/11/2009 - DONE
003 - 11/10/2009 - 15/12/2009 - DONE
004 - 12/10/2009 - NULL - ON GOING
005 - 14/11/2009 - 16/12/2009 - DONE

I think that this is think is possible .....but i really don't know how to do it :/
I would really be great full of any help