Forums

This topic is locked

Syntax error missing operator in query expression

Posted 14 Mar 2002 02:30:45
1
has voted
14 Mar 2002 02:30:45 frog jumps posted:
<font face='Tahoma'>I cannot figure this one out...any idea...besides that I may be a moron...

SQL:

SELECT Customers.CustID, Customers.CompanyName, Customers.ContactFirstName, Customers.ContactLastName, Customers.Address, Customers.Address2, Customers.Address3, Customers.City, Customers.State, Customers.ZipCode, Customers.PhoneNumber, Customers.FaxNumber, Customers.AltPhone, Notes.TaskID, Notes.nCustID, Notes.Employee, Notes.Time, Notes.Date, Notes.Note
FROM Customers LEFT JOIN Notes ON Notes.nCustID=Customers.CustID GROUP BY Customers.CustID, Customers.CompanyName, Customers.ContactFirstName, Customers.ContactLastName, Customers.Address, Customers.Address2, Customers.Address3, Customers.City, Customers.State, Customers.ZipCode, Customers.PhoneNumber, Customers.FaxNumber, Customers.AltPhone, Notes.TaskID, Notes.nCustID, Notes.Employee, Notes.Time, Notes.Date, Notes.Note ORDER BY Customers.CustID, Customers.CompanyName, Customers.ContactFirstName, Customers.ContactLastName, Customers.Address, Customers.Address2, Customers.Address3, Customers.City, Customers.State, Customers.ZipCode, Customers.PhoneNumber, Customers.FaxNumber, Customers.AltPhone, Notes.TaskID, Notes.nCustID, Notes.Employee, Notes.Time, Notes.Date, Notes.Note
WHERE CustID = varNote

Variable:

Name : varNote
Default value: 1
Runtime value: Request.QueryString("Customers.CustID"
</font id='Tahoma'>

Reply to this topic