MySQL Delete with JOINS

[dj4uk]

I have 4 joined tables:
tbl_users (primary key user_id)
tbl_user_subject_registration (foreign key user_id)
tbl_user_results (primary key result_id, foreign key user_id)
tbl_user_question_register (foreign key result_id)

I would like to delete all records in all tables related to a user_id supplied. Ideally this should be within one Delete statement. I've tried various things but always get a syntax error. Can anyone point out where I'm going wrong. Latest attempt below.

DELETE  	tbl_users.*, tbl_user_subject_registration.*, tbl_user_results.*, tbl_user_question_register.*
FROM		tbl_users 
INNER JOIN	tbl_user_subject_registration 
ON		tbl_users.user_id = tbl_user_subject_registration.user_id 
INNER JOIN	tbl_user_results 
ON		tbl_users.User_id = tbl_user_results.user_id 
INNER JOIN	tbl_user_question_register 
ON		tbl_user_results.result_id = tbl_user_question_register.result_id 
WHERE 		tbl_users.user_id = ?

Cheers

DJ