SQL - Multiple Joins resulting in too many results.
Posted on 2011-03-15
Ive tried to write a query with multiple inner joins. I have 3 tables (TBL_1, TBL_2, TBL_3) all linked by the field ACCOUNT_ID.
I need to join the tables so I can acess fields from all three tables that are linked to the ACCOUNT ID.
I can get one inner join to work, but when I tack on a second my results a multiplied 3000 times when there should only be 1 or 2 results.
If anyone can provide a simple example I would appreciate it. All the ones Ive found on google are overly complicated and I dont understand how to implement them.