Is there a way to use CMP to to insert(ejbStore) which requires to join multiple table?
example insert clause:
insert into table t1 select c1,c2,c3 from t2,t3 where t2.id=t3.id;
just want to avoid BMP.
no. You might be able to do a db query in ejbCreate to get the values you want from other tables, though. I've never tried it.