-
joins
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|