At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!
SELECT AccessList.ALMYID, AccessList.FirstName, AccessList.LastName, AccessList.ClassStanding, Seminars.SeminarDetails, AccessList.TermGPA, AccessList.MYCompletedCredits, StudentSeminars.SHasAttended, StudentSeminars.SSeminarID, AccessList.CumulativeGPA, AccessList.CompletedCredits, AccessList.IsTransfer, Demographics.DEmail, CASE WHEN (StudentSignature.SSigID IS NULL) THEN 'No' ELSE 'Yes' END AS Signed FROM AccessList INNER JOIN StudentSeminars ON AccessList.ALMYID = StudentSeminars.SMYID INNER JOIN Seminars ON StudentSeminars.SSeminarSelected = Seminars.SeminarID INNER JOIN Demographics ON StudentSeminars.SMYID = Demographics.DMYID INNER JOIN StudentSignature ON StudentSeminars.SMYID = StudentSignature.SSMYID WHERE (Seminars.SeminarID = @SeminarID)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.