Page 1 of 1

joins examples on multiple tables

Posted: Sat Jan 08, 2011 1:27 am
by sasanka
hi,
can u take 5 tables with primary keys and foreign keys and explain
how to select data from them using joins

like if we want to take 5 table data we cant take it directly we have to involve all other 4 tables

pls explain this with an example it will be useful for many of them.

Posted: Sun Jan 23, 2011 10:45 am
by Gyani
Hi Sasanka,

its very gud question. I can suggest u go through online tutorial.
For eg. there is another option to select data from 5 diffrent tables without joins which s nested queries. u ll learn such smal small things...

http://www.sql-tutorial.net/SQL-JOIN.asp

Thanks,
Gyani.