I am trying to join 5 tables and I have written a query Like this but I am getting invalid Identifier mvk when I run this query.
SELECT *
FROM CBH.MARKETINGCBH mcbh
JOIN CBH.MCBH_INTERESSES mi on mi.MARKETINGCBHID = mcbh.MARKETINGCBHID
JOIN CBH.INTERESSES i on i.INTERESSESID = mi.INTERESSESID
JOIN CBH.MAILING_VIA_KANAAL mvk on mvk.MAILINGVIAKANAALID = i.MAILINGVIAKANAALID
JOIN CBH.RESPONS_INTERESSES ri on ri.INTERESSESID=mvk.INTERESSESID
WHERE mcbh.CBHID = '10351720'
AND mvk.MAILINGKANAALCODE = 'EMA'
AND i.SOORTINTERESSECODE = 'INT'
AND mi.DATUM > (SELECT mi2.DATUM
FROM CBH.MARKETINGCBH mcbh2
JOIN CBH.MCBH_INTERESSES mi2 on mi2.MARKETINGCBHID = mcbh2.MARKETINGCBHID
JOIN CBH.INTERESSES i2 on i2.INTERESSESID = mi2.INTERESSESID
WHERE i2.SOORTINTERESSECODE = 'DES'
AND mcbh2.CBHID = '10351720'
AND i2.MAILINGVIAKANAALID = i.MAILINGVIAKANAALID);
Aucun commentaire:
Enregistrer un commentaire