feedback

(Solution document) I'm having trouble with an SQL Query. #4 on Assignment 1 MIS6873. Pirate Sport Database Table/Fields #4) List all customers, along with the Sales ID,...


I'm having trouble with an SQL Query. #4 on Assignment 1 MIS6873. Pirate Sport Database Table/Fields


#4)    List all customers, along with the Sales ID, who purchased products during November of 2015. Be sure to string their last and then first name together leaving no extra spaces between them. Sort by Sales ID.


Heres what I came up with:

Select RTRIM(CustFirstName)+RTRIM(CustLastName)

FROM SALE, CUST

WHERE SaleCustID=CustID

AND SaleDate='November2015'

Order by SaleID;


but it wont RUN. How do I put in the date?

 







About this question:

Pay using PayPal (No PayPal account Required) or your credit card. All your purchases are securely protected by .
SiteLock