DROP VIEW MyView
? INDBC('Catalogue', 'Table')  && must be true. Change Table to View if needed
? INDBC('Selections', 'Table')  && must be true. Change Table to View if needed
CREATE SQL VIEW MyView AS ;
SELECT Selections.*, Catalogue.cproduct;
 FROM  catalogue!catalogue INNER JOIN catalogue!selections ;
   ON  Catalogue.iid = Selections.iproductid