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

[nickthomas25]

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?

[guido2004]

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 :: 12.2.9.1 JOIN Syntax

[r937]

please help..me by explaining different types of join

see http://www.sitepoint.com/forums/3234442-post18.html

[nickthomas25]

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!!

[r937]

but can u tell me different type of normalization as well

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