I have a pretty simple issue but my several attempts don't return desirable results. The following query updates the field of DE (noImax) with "true" for those who meet specified criteria. What I need is to apply this "true value" for all who does not meet it (remaining audience, not equality will not work in this case). EXCEPT would work for it but, apparently, it's not supported in SFMC. I tried to use NOT EXISTS but it did not work as well (maybe, it was syntax issue)
SELECT clientIdentifier, dateOfRegistration, phoneNumber, locale, phoneAppr, emailAddress, emailAppr, sourceOfReg, dateOfBirthday, gender, memberClub, sendEmail, sendSms, sendViber, sendPush, kinomama, originalDubbing, forKids, documentaries, broadcast, vr, newsDelivery, personalDelivery, surveyAfterMovie, clientFirstName, clientLastName, bonuses, 'true' AS noImax, no4dx, noRelux, noVR, noVIP, noKinomarket, noBuySite, noBuyMA, lastBuyCity, daysSinceRegistration, countVisitsMonth, sumTicketsPrice, sumBarPrice, avgBillTikets, avgBillBar, daytimeWeekdays, priceSensitivity, riskOutflow, rfm FROM Partners_test LEFT JOIN TransactionTickets ON Partners_test.clientIdentifier = TransactionTickets.clientId WHERE TransactionTickets.technology = 'IMAX 3D' OR TransactionTickets.technology = 'IMAX 2D'
Thank you for your time!