need to join
Posted on 2003-11-17
Ok!, been at it for a while now with out any sleep (36 hours) and I can't think straight any more, So I as you for a salution.
I have multiple DB (sql2K)
each built independently to the other.
the pk/fk for all recods is "exid" within its tables
the seconds member PK/FK is "MID" within its tables
now I must join these record into a db contacts (PK/FK) will be "CID"
this table will now become the parent talbe for all dbs.
hence the CID will be the FK constraint that will assign all other records
cid will have a one to many relationship with expo and with member
I have already place all records from member and expo, I have made sure that I do not have any duplicate record. now all these records now have a new id "CID" now I want to propagate this CID down to all other tables ExPO and Member. I have created a new column in both tables to rep contact id.
now what I have tried and failed due to sleep is to take the cid and addit to both expo and member table where the following criteria is met( this creteria will be deleted out of child tables aftere testing) conatact address,city,state,zip,email are the same for both member and expo.
this is what I have I am stuck on the update portion(YaaaaawWWWnnn)
I know it will be simple. just to tired to proceed with thought.
I am going to get a coffee and a smoke and try to revive.
<cfquery name="getex" datasource="uspoultryintranet">
Select * from currentex
<cfquery name="getcn" datasource="uspoultryintranet">
Select contactid from curcontacts
<!--- update expo table with new CID goes here--->