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 t...
  • 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.