SQL Query issues
I have been working on this for a few days and a cannot figure out where
the error is. The query is:
Select distinct p.PkgID, p.PkgName, p.PkgCost, c.CustFName || ' ' ||
c.CustLName as "CUSTOMERNAME"
FROM Subscription s, Package p, Customer c
WHERE p.PkgID = s.PkgID
AND c.CustID = s.CustID
AND to_date
(s.StartDate, 'Mon DD, YYYY')=
to_date
(&StartDate, 'Mon DD, YYYY')
ORDER BY p.PkgID;
I keep getting: SQL Error: ORA-00907: missing right parenthesis 00907.
00000 - "missing right parenthesis".
I have racked my brain and cannot find the issue. Any help would be much
appreciated.
No comments:
Post a Comment