View Single Post
  #5 (permalink)  
Old March 14th, 2006, 05:26 PM
Subuana Subuana is offline
Authorized User
 
Join Date: Mar 2006
Location: London, , United Kingdom.
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Peko!! i tried putting INNER JOIN before WHERE but it says 'syntax error in JOIN operation' is this format correct?

"SELECT StudentProfile.StudentID, StudentProfile.FirstName, StudentProfile.LastName, StudentProfile.Course, StudentProfile.Semester, Accounts.TotalFee, Accounts.Installments, Accounts.AmountsPaid, Accounts.DateOfPay, Accounts.DuesRemaining, Accounts.DueDate FROM StudentProfile, Accounts INNER JOIN Accounts ON StudentProfile.StudentID=Accounts.studentID where StudentProfile.StudentID=" & a & ""

Ana

Reply With Quote