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