Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Mysql Copy tables

5:09 pm on Jan 30, 2009 (gmt 0)

Full Member

10+ Year Member

joined:May 13, 2003
votes: 0

Basic reporting system:

Table1 contains a Unique ID and a Grade (Added from SIMS)
Table2 contains that same Unique ID and the Admission Number (Pupil Details)
Table3 contains an Admission Number and a Comment (Report Content)

Table1 - Col1 = UniqueID and Col2 = Grade

Table2 - Col1 = UniqueID and Col2 = Admission Number

Table3 - Col1 = AdmissionNumber Col2 = Comment Col3 = GradeCopy

I need to copy the 'Grade' from 'Table1' to 'Table3' but match that against the Unique ID and Admission number held in 'Table2'.

I need GradeCopy(Table3) to match Grade(Table1) but check that the correct grade is matched against the correct admission number after being check against the Unique ID.


Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members