What do you want to select? explain in English and I'll help construct the SQL.

very rarely do you need join's. I prefer multiple queries, saves headaches.