insert and join table and CMP

butterflee Feb 26, 2002 4:35 PM

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.

Thanks!

1. Re: insert and join table and CMP

davidjencks Feb 26, 2002 4:54 PM (in response to butterflee)

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.
Actions