ca.portal.admin

Re: SQL question

Discussion created by ca.portal.admin on Nov 20, 2006
No guarantees - but you could try the following:

Select b1.rowid as b1_dbkey,
a1.rowid as a1IMPLdbkey,
a2.rowid as a2IMPLdbkey
from b b1,
a a1,
a a2,
where criteria-for-selecting-B
and ""IMPLOSION"".B.A
and ""EXPLOSION"".B.A
;

Like I said no guarantees but it's worth a try - cheers - Gary

Outcomes