WebWatcher
New Member
Hello
I have a quick question which i hope somebody can answer.
I have to tables with in a mysql database set out like below
Table 1 - ID - USER - SCORE - SECTION
Table 2 - ID - Guest - SCORE - SECTION
(Not exactly the same set up but using the above as an example.)
I need to keep both table so can somebody tell me how I can query the database so they add the two table together and display all records in order of SCORE.
Hope that is clear enough and somebody can help
thanks in advance
I have a quick question which i hope somebody can answer.
I have to tables with in a mysql database set out like below
Table 1 - ID - USER - SCORE - SECTION
Table 2 - ID - Guest - SCORE - SECTION
(Not exactly the same set up but using the above as an example.)
I need to keep both table so can somebody tell me how I can query the database so they add the two table together and display all records in order of SCORE.
Hope that is clear enough and somebody can help
thanks in advance