Forums
This topic is locked
Syntax error missing operator in query expression
Posted 23 years ago
1
has voted
23 years ago 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'>