sql error: Unknown column 'redbcalgary.rets_property_listing.Matrix_Unique_ID' in 'on clause'
SELECT *,'2' FROM (SELECT * FROM redbcalgary.rets_property_listing INNER JOIN redbcalgary.creb_openhouse ON redbcalgary.rets_property_listing.Matrix_Unique_ID = redbcalgary.creb_openhouse.Listing_MUI WHERE City='Two Island Point' AND IBGTable<>'cal' ORDER BY ListPrice DESC LIMIT 0,20) a UNION ALL SELECT *,'2' FROM (SELECT * FROM redbcalgary.excl_property_listing INNER JOIN redbcalgary.creb_openhouse ON redbcalgary.rets_property_listing.Matrix_Unique_ID = redbcalgary.creb_openhouse.Listing_MUI WHERE City='Two Island Point' AND IBGTable<>'cal' and ListAgentMLSID in ('CFAWCEKA','CLINSTJO','CPETERJO2','CPROFENI','CBONNEAL','CMOLINTA','CSCARCLE','CMckelke','CDEJONPE','CBIEBRER','Clockhma','CMORRIKE','CCRICKSA','Cbeckecl','Cconroji','Clotosjo','Cpilipta') ORDER BY ListPrice DESC LIMIT 0,20) b