How to simplify this intersect query?

0 votes

2 answers

93 views

query-performance t-sql optimization powerbi

                              SELECT * from M
    left JOIN K on M.id = k.id
    left JOIN W on K.str = W.str where str = N'أخبار'
     
    INTERSECT
     
    SELECT * from M
    left JOIN K on m.id = k.id
    left JOIN W on K.str = W.str where str = N'فلسطين'

How else to get all rows in M that have a relationship to both أخبار AND فلسطين in W?
                        

Asked by simpatico (99 rep)

May 19, 2024, 12:17 PM
Last activity: May 20, 2024, 01:01 PM

How to simplify this intersect query?

Related Questions