Database error for my query

[MyPornLife.info]

hey i used this query but its showing error

PHP Code:

$db->query_read("SELECT * FROM " . TABLE_PREFIX . "userdata AS userdata LEFT JOIN " . TABLE_PREFIX . "userid AS userid WHERE userdata.xID = userid.xID ORDER BY userdata.time DESC"); 


my ultimate goal is: first collect xID from table userid then collect all from userdata where xID is those collected xID

plz help me

[Lynne]

It really helps to know what the exact error is. You need to LEFT JOIN ON something.

PHP Code:

$db->query_read("SELECT * FROM " . TABLE_PREFIX . "userdata AS userdata 
LEFT JOIN " . TABLE_PREFIX . "userid AS userid ON (userdata.xID = userid.xID) 
ORDER BY userdata.time DESC");