[H-GEN] SQL query needed

[Dale Stewart]

[ Humbug *General* list - semi-serious discussions about Humbug and     ]
[ Unix-related topics. Posts from non-subscribed addresses will vanish. ]

Hi Paul,

The query would look something like

select Students.STUDID, Students.name, maths1, english1 
from Students, Results, Tests
where Students.STUDID = Results.STUDID
and Results.TESTID = Tests.TESTID
order by Students.STUDID

I think thats should work

regards

Dale



Paul Clarke wrote:

>[ Humbug *General* list - semi-serious discussions about Humbug and     ]
>[ Unix-related topics. Posts from non-subscribed addresses will vanish. ]
>
>Hi all,
>
>I am working on a mySQL data base that records student results. The main
>tables are along the lines of:
>
>Students = STUDID, name, class
>1000, Bill, 5a
>1002, Sue, 5a
>
>and 
>
>Results = STUDID, TESTID, result
>1000, 1, A
>1002, 1, B
>1000, 2, B
>1002, 2, C
>
>and
>
>Tests = TESTID, description
>1, maths1
>2, english1
>
>I want to have a query that will return:
>STUDID, name, maths1, english1
>1000, Bill, A, B
>1002, Sue, B, C
>
>What would the query look like? I am programming it all in php so it is
>possible to have the query generated to something like "select STUDID,
>name, maths1, english1 from ..."
>
>Thanks
>
>Paul
>
>Site Dynamics - Paul Clarke
>paul at sitedynamics.com.au
>0414 367 747
>
>
>--
>* This is list (humbug) general handled by majordomo at lists.humbug.org.au .
>* Postings to this list are only accepted from subscribed addresses of
>* lists 'general' or 'general-post'.  See http://www.humbug.org.au/
>
>  
>



--
* This is list (humbug) general handled by majordomo at lists.humbug.org.au .
* Postings to this list are only accepted from subscribed addresses of
* lists 'general' or 'general-post'.  See http://www.humbug.org.au/