need help contructing an SQL stament

[thepreacher]

I am using MySQL version 4 and i need help in constructing an SQL stament. I need to retrive 3 sets of information from 3 different tables. The tables are Recipient, Customer and Transaction. The relationship is as follows: The customerID can be found in both the Recipient and Transaction tables. The Recipient ID can be found in the Transaction table.

From the recipient table i need firstname, lastname and address. From the Customer table i need the firstname and surname. From the Transaction table i need the transaction date and the transaction amount.

I will be delighted if someone can help. I have never written a mysql join sql comprising more than 2 tables before.

Thanks.

[VGR]

you've all the "billes" to solve the problem yourself ;-)

select c.transaction_date,c.trans_amount,a.firstname,a.lastname,a.address,b.firstname AS cust_fst, b.surname AS cust_surn  from transaction AS c LEFT JOIN recipient AS a ON (a.id=c.recipient_id) LEFT JOIN customer AS b ON (b.id=c.cust_id);

your problem lied in :
- assigning ALIASES to tables referenced in a JOIN (MySqld can do this)
- assigning ALIASES to columns being synonyms (firstname and surname, mainly)