>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.

What is your database engine? Access? Use the Access Query designer.

If it is another engine, you could create a dataenvironment, add a command and the you have the Query Builder button that will help you build query like the one you want.

Your query will look like this:
SELECT *
FROM Customer INNER JOIN DayTrans
ON Customer.CustCode = DayTrans.CustCode