Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- keyTable
- -----------------------------------------
- | uaID | userID | key | appName |
- |---------------------------------------|
- | 1 | 7 | ABC01 | Physics |
- | 2 | 9 | DEF20 | Geometry |
- | 3 | 12 | XJG14 | Biology |
- | 4 | 19 | DAF09 | Chemistry |
- | 5 | 27 | KYT78 | Algebra |
- | 6 | 29 | PLF43 | Statistics|
- | 7 | 34 | COG89 | Geology |
- | 8 | 45 | HYL72 | Art |
- | 9 | 48 | TSK45 | History |
- | 10 | 53 | BBS94 | GeoChem |
- | 11 | 59 | DOD10 | BioChem |
- | 12 | 27 | HKV62 | Music |
- -----------------------------------------
- dataTable01
- -----------------------------------------------
- | uaID | sector | subSector | topic |
- |---------------------------------------------|
- | 2 | circle | volumn | measure |
- | 7 | triangle | hypotenuse |pythagoras |
- | 8 | square | | |
- | 11 | triangle | hypotenuse |pythagoras |
- -----------------------------------------------
- dataTable02
- ---------------------
- | uaID | topic |
- |-------------------|
- | 1 | door |
- | 3 | window |
- | 9 | porch |
- | 12 | |
- ---------------------
- dataTable03
- -----------------------------------------------
- | uaID | sector | subSector | topic |
- |---------------------------------------------|
- | 4 | cat | feline | kitty |
- | 5 | dog | canine | rover |
- | 6 | kangaroo | marsupial | jack |
- | 10 | bunny | leporidae | peter |
- -----------------------------------------------
- users
- ------------------------------------------------------------------------
- | userID | Title | firstName | lastName | email |
- |----------------------------------------------------------------------|
- | 7 | Dr | Melissa | Smith | mel@email.com |
- | 9 | Mr | Bob | Andrews | bob@email.com |
- | 12 | Miss | Clare | Greco | clare@email.com |
- | 19 | Mr | Dan | Fonseca | dan@email.com |
- | 27 | Mr | Matt | Jones | matt@email.com |
- | 29 | Mr | Chris | Nimmo | chris@email.com |
- | 34 | Mrs | Lisa | Araujo | lisa@email.com |
- | 45 | Miss | Raquel | Bailey | raquel@email.com |
- | 48 | Dr | Steven | Dowd | steven@email.com |
- | 53 | Prof | Roger | Hesp | roger@email.com |
- | 59 | Prof | Sally | Bryce | sally@email.com |
- | 65 | Mrs | Elena | Eraway | elena@email.com |
- ------------------------------------------------------------------------
- -------------------------------------------------------------------------------------------------------------------------------
- | uaID | key | appName | sector | subSector | topic | title | firstName | lastName | email |
- |-----------------------------------------------------------------------------------------------------------------------------|
- | 1 | ABC01 | Physics | | | door | Dr | Melissa | Smith | mel@email.com |
- | 2 | DEF20 | Geometry | circle | volumn | measure | Mr | Bob | Andrews | bob@email.com |
- | 3 | XJG14 | Biology | | | window | Miss | Clare | Greco | clare@email.com |
- | 4 | DAF09 | Chemistry | cat | feline | kitty | Mr | Dan | Fonseca | dan@email.com |
- | 5 | KYT78 | Algebra | dog | canine | rover | Mr | Matt | Jones | matt@email.com |
- | 6 | PLF43 | Statistics| kangaroo | marsupial | jack | Mr | Chris | Nimmo | chris@email.com |
- | 7 | COG89 | Geology | triangle | hypotenuse |pythagoras | Mrs | Lisa | Araujo | lisa@email.com |
- | 8 | HYL72 | Art | square | | | Miss | Raquel | Bailey | raquel@email.com |
- | 9 | TSK45 | History | porch | | | Dr | Steven | Dowd | steven@email.com |
- | 10 | BBS94 | GeoChem | bunny | leporidae | peter | Prof | Roger | Hesp | roger@email.com |
- | 11 | DOD10 | BioChem | triangle | hypotenuse |pythagoras | Prof | Sally | Bryce | sally@email.com |
- | 12 | HKV62 | Music | | | | Mr | Matt | Jones | matt@email.com |
- -------------------------------------------------------------------------------------------------------------------------------
- $sql = "SELECT keyTable.uaID, keyTable.userID, keyTable.key, keyTable.appName, dataTable01.sector, dataTable01.subSector, dataTable01.topic, dataTable02.topic, dataTable03.sector, dataTable03.subSector, dataTable03.topic, users.title, users.firstName, users.lastName, users.email FROM keyTable LEFT OUTER JOIN dataTable01 ON keyTable.uaID = dataTable01.uaID LEFT OUTER JOIN dataTable02 ON keyTable.uaID = dataTable02.uaID LEFT OUTER JOIN dataTable03 ON keyTable.uaID = dataTable03.uaID LEFT OUTER JOIN users ON keyTable.userID = users.userID";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement