Forum Discussion

gtamir's avatar
gtamir
Post Patron
8 years ago
Solved

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.

  • Anonymous's avatar
    Anonymous
    8 years ago

    gtamir Use the "Left Outer" option. but you need to select the large table as the first one.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    gtamir Use the "Left Outer" option. but you need to select the large table as the first one.