How to join more than 3 to 4 tables with out getting Cartesian products..
Let us take an example I am having table “A” table “B”.
In A table I am having “a” primary key and “b” forging key from Table B and other columns “ab”, “aasd”,….
In B table I am having “b” primary key and “bb” corresponding value…
I want to display entire A table values with “bb” value mean corresponding b value in B table….
I write query like this but it is giving Cartesian products..
Select a, bb, ab, …… from A, B where A.b = B.b;

How to over come this problem….
Thanks & Regards,
RAM