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'>