I need to join 2 tables to link the key and reference to the
other fields.

Eg: Table : Customer (customer table with detial particular)
Table : DayTrans (keeps daily transactions)

The DayTrans table has a CustCode and I need to link it to
Customer table by "CustCode" and retrieve the Customer.Address
field. How could I do it by the SELECT statment?
Is it using the JOIN INNER or OUTER? Pls advise, thanks.