Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by rchinoy
-
SQL query error
Never mind. I just did a search of the mySQL docs and found that "Returns" (one of my table names) is a reserved word. I changed the table name and I'm changing my code now. -
SQL query error
I'm using the query: -------------------------------------- SELECT ORD_ID, RETURN_ReqDate, MAX(ReturnItems.RETSTAT_ID) AS MaxRetItemStatusID, COUNT(RETITEM_ID) AS RETURN_ItemCount FROM Returns, ReturnItems WHERE (Returns.CUST_ID = #Session.CUST_ID#) AND (ReturnItems.RETURN_ID=Returns.RETURN_ID)...
