Re: matching rows differing only by fkey,pkey

Thanks for your suggestion to use curval(), that will be useful.  I'd
entirely forgotten about that function.  That likely will help when combined
with Richard's suggestion and an idea I already had.

I'm sorry that the problem wasn't clearer.  The best way I can describe it
is like this: The end result is to duplicate the data for a particular record in table "a" so that all of it's related
datain tables "b" and "c" is duplicated.
 
Where "b" is the middle table in a many to many relationship.  For example,

- a ----    - b ----    - c ----aid  <--+   bid  <--+   ciddata1   +-->aid     +-->biddata2       field1
info1date3      field2      info2
 

SELECT a.*,b.*,c.* from a,b,c where b.aid = a.aid and c.bid = b.bid;

So, the goal is to duplicate an object that is made up of the data stored
across these three tables. 

Any suggestions?

Matthew Nuzum        | ISPs: Make $200 - $5,000 per referral by
www.followers.net        | recomending Elite CMS to your customers!
matt@followers.net    | http://www.followers.net/isp