SELECT more than one table

[harkly]

I am selecting info from around 13 tables and I was wondering if there is a more efficient way to do this then what I have done. Mine does work so just wondering.

 

WHERE about_me.userID = 'test' AND pets.userID = 'test'  AND appearance.userID = 'test'  AND eg.userID = 'test'  AND interest.userID = 'test'  AND exercise.userID = 'test'  AND art.userID = 'test'  AND hobbies.userID = 'test'  AND music.userID = 'test'  AND rlat.userID = 'test'  AND user.userID = 'test' AND photos.userID = 'test' AND bkgd.userID = 'test'") or die(mysql_error());

[killerb]

When you have data scattered all around different tables, the only way to optimize a heavy join is to index periodically and select your *whatever_id* from the index table. This is common practice for example on searches where the best efficiency is required on select whereas a few seconds delay on update/insert is tolerable.

[fenway]

I also doubt you mean AND.