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

    query join clause in cmr

    James Newbie

      Hi,

      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?

      Customer
      id numeric,
      name varchar,
      addr1 varchar

      Customertrans
      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