How to use different types of join ..while building connection to the server?

Hi guys…i was trying to use join for the building my tables properly…but could get as to which table join should i use…please help…me by explaining different types of join and when to use them?

You don’t use joins to build tables. You use them to join tables in a query.
What join you need to use depends on what you want to achieve.

MySQL :: MySQL 5.5 Reference Manual :: JOIN Syntax


thanks…buddy this is really helpful…
but can u tell me different type of normalization as well…i find them really difficult to learn or understand!!

i could, but i wouldn’t be saying anything new compared to the thousands of tutorials out there already

just keep searching until you find a good one :wink: