View Single Post
  #6 (permalink)  
Old March 14th, 2006, 07:27 PM
peko peko is offline
Authorized User
 
Join Date: Mar 2006
Location: Bratislava, , Slovakia.
Posts: 80
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by Subuana
 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

Kick item accentuated with bold and try again, or send me please, fields description of these tables (I try query syntax home)

Peko

Reply With Quote