Inner Join more than one table

[ts10]

Hey,

I can't find the code to allow me to Inner Join three tables - I have it working fine with two:

$result = mysql_query("SELECT training_request_attending.request_name,training_request_attending.request_company,training_request_attending.request_email,fud_users.phone 
									FROM training_request_attending 
									INNER JOIN fud_users 
									ON training_request_attending.request_id = fud_users.id
									WHERE (request_class_id = '30' AND request_assigned = 'assigned') ");

I tried this:

$result = mysql_query("SELECT training_request_attending.request_name,training_request_attending.request_company,training_request_attending.request_email,fud_users.phone,training_hot_questionnaire.devtype 
									FROM training_request_attending 
									INNER JOIN fud_users 
									ON training_request_attending.request_id = fud_users.id
									INNER JOIN training_hot_questionnaire
									ON training_request_attending.request_id = training_hot_questionnaire.hot_userid
									WHERE (request_class_id = '30' AND request_assigned = 'assigned') ");

But no good. I only got one record returned where I was returning 12 before.

Thanks!!

[AstroTeg]

Sounds about right. You may want a left join instead...