MYSQL SQL Statement Question

Is there a way to search 3 tables or more at once and return all information that it finds? If I do a inner join it will only return if there are matches in the tables. If I do just a left join it returns the left if nothing in the right is found and visa versa for a right. Im using a unique id btw to search for any matches in the 3 tables. So in english I want to: Search 3 tables at once trying to find any field matching a number I pass to the query. Even if no info is found in table 1 or table 3 I still want to return the information in table 2 since there was a match found. How can I do that? BTW Im using mysql 3.23x Thanks Silly __________________________________________________ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com