Posts by John Linux which have been Voted Up

Hi Guys,

Thanks for the input,
thoroughly appreciated.

Worked it out earlier like this:

SELECT stuID
FROM results
WHERE stuID
IN (

SELECT stuID
FROM results
WHERE course = 'PHY2'
)
AND course = 'MAM1'

I assure you, I did a fair amount of thinking before posting on the forum, hence taking the time to do so. I didn't feel the need to track and post all my failueres!

Regards,
John

Have done a complete re-do, simplying functions as I went along.. Didn't pinpoint the error, but second time around the problem is solved =)