Need MySQL Expert HELP with a 3 table join Work via SKYPE Screenshare
$30-100 USD
Pagado a la entrega
I need to perform a 3 table join to pull and sort data correctly from existing database.
Story:
I have a page where students take tests so studentid,results, score, standard , and date are recorded into a table named "results"
Before they take the test they must first watch a short video. After they watch the video a record is sent into a different table named cipa_video_timestamp with records studentid, cpstandard, schoolid, and timestamp. I must say this table contains duplicate entries
then I also have another table named "students" with the name of all students.
I have like 90% of the script to display the data the way I want but when I do a join it does not display the timestamps correctly.
I'm expecting this job to take from 30 minutes to 3 hrs max. We'll be working together
If you know ASP programming HUGE PLUS but not necessary.
Nº del proyecto: #2786809