Forum Discussion

lcerrapa's avatar
lcerrapa
Icon for Helper I rankHelper I
9 years ago
Solved

Exclude rows on table based on another table at query design

Hello. I don't find the answer to this question, I hope you can help me.   I have a query against a database that obtains data:   select year, projection from DimProjections where <conditions> ...
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Perhaps a Merge query using a Right Anti join (or Left Anti join depending on which one of your queries you consider "first".

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Perhaps a Merge query using a Right Anti join (or Left Anti join depending on which one of your queries you consider "first".

  • lcerrapa's avatar
    lcerrapa
    Icon for Helper I rankHelper I
    9 years ago

    Thanks a lot, it works perfect!!