9 Replies Latest reply on Oct 10, 2002 11:06 AM by James

    query join clause in cmr

    James Newbie


      I have been trying to setup a CMR with a customer table and a custmer transaction table. It is more than just a simple id FK join though. Can JBoss support the following using CMP and CMR? How is the join defined since type isn't in the custmer table?

      id numeric,
      name varchar,
      addr1 varchar

      id numeric,
      customerid numeric,
      amount numeric,
      type numeric

      The join query is
      select c.name,c.addr,t.amount from customer c,customertrans t where t.customerid=c.id and t.type=1