General information
Category:
Database DAO/RDO/ODBC/ADO
>>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
I need to list all fields in DayTrans and link to Customer only to get
the Address. Am I right to code as:
SELECT DayTrans.CustCode, DayTrans.CustName, Customer.Address
FROM DayTrans INNER JOIN Customer
ON DayTrans.CustCode = Customer.CustCode
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only