Hassle-free live chat software re-imagined for business growth. 2 users, always free.
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)
|Calculate values in an array||18||33|
|Need a starter for ETL protocol?||4||42|
|Whats wrong in the below query? Any help would be appreciated...||2||15|
|ISDATE() not working properly on my table? Any suggestions.||7||10|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!