Welcome to WebmasterWorld Guest from 50.19.34.234

Forum Moderators: open

Message Too Old, No Replies

Mysql Copy tables

     

humpingdan

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

10+ Year Member



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.

 

Featured Threads

Hot Threads This Week

Hot Threads This Month