Forum Discussion
gtamir
8 years agoPost Patron
Merge queries
If I have two tables, one with 100 rows and one with 90 rows, I want to join them and I expect to have 100 rows in the merged table.
What kind of join do I have to use. I used full outer join, bot the result was about twice thr number of rows.
- Anonymous8 years ago
gtamir Use the "Left Outer" option. but you need to select the large table as the first one.
1 Reply
- AnonymousNot applicable
gtamir Use the "Left Outer" option. but you need to select the large table as the first one.