View Single Post
  #3 (permalink)  
Old March 14th, 2006, 08:49 AM
Subuana Subuana is offline
Authorized User
Join Date: Mar 2006
Location: London, , United Kingdom.
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts

hi peko!

Data types of StudentID is Numeric,
i tried using INNER JOIN but now it says missing operator in the sql query. would u be able identify whats missing in this statement?

"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 where StudentProfile.StudentID=" & a & " INNER JOIN Accounts ON StudentProfile.StudentID=Accounts.StudentID;"

thanx Ana

Reply With Quote