1 Reply Latest reply on Oct 12, 2002 12:42 PM by Alexey Loubyansky

    How to implement a simple join in CMP?

    Louis Newbie

      Hi, I have the following sql statement:

      SELECT * FROM table_a as a INNER JOIN table_b as b on a.id = b.key WHERE a.ownerid = '1234';

      which will return a recordset contains all the columns of table_a plus all the columns of table_b. I am wondering if this can be implemented by CMP.