Forum Discussion

lcerrapa's avatar
lcerrapa
Helper 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>

 

The result of this query is ALWAYS one row with this structure:

 

YEAR    PROJECTION

------   -----------------

2016    PROJECTION10

 

I have a FactSales table with many years and many projections (and many other fields), and I need to obtain all the rows except the result of the previous query (all data without 2016 year and PROJECTION10 projection combination).

 

How can I do this?

 

Thanks in advance.

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

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community 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".

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi lcerrapa,

     

    smoupre's reply seems well, perhasps you can try it.
    In addition, if you use the sql database, you can directly use t-sql query to merge the table at sql statement option:

     

     

    Regards,

    Xiaoxin Sheng