jeudi 7 juillet 2016

Joining of Four or More Tables

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