I'm working on a example query. So I have a CUSTOMER table and a BID table.
Basically I want to see all of our customers who receieved a bid. This is the query I'm working on:
SELECT CUSTOMER.CUST_FNAME, CUSTOMER.CUST_LNAME, BID.BID_DATE
FROM CUSTOMER C
WHERE BID.DATE beween to_date('03/01/2014','MM/DD/YYYY') and to_date('03/31/2014','MM/DD/YYYY') JOIN BID B
ORDER BY C.CUST_FNAME
However whenever I run it, I get this error message:
ORA-01747: invalid user.table.column, table.column, or column specification
Can anyone help me fix my query?