ahmed24 - 12:34 am on Dec 30, 2012 (gmt 0)

that's great. thanks. can you kindly show me how i can use the same logic to join the 3rd result so i can understand it better? using this logic I am guessing I can keep joining tables to get data from other tables by linking values up e.g. user_id?

also, if i'm selecting lets say user_id from one table and contact_id from another table, if these tables had duplicate named columns, will this effect the result? I am assuming it shouldnt as long as I am not calling lets say user_id from two different tables, correct?

thanks