homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Mysql Copy tables

10+ Year Member

Msg#: 3838333 posted 5:09 pm on Jan 30, 2009 (gmt 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.


Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved