I have two table. Table 1 is called eventInformation and table 2 is called onlineOrder. What I need to do is this. I need a list of jobNumbers found in the eventInformation table that have a matching jobNumber in the onlineOrder table. I wrote this...
FROM eventInformation AS ei INNER JOIN
onlineOrder AS oo ON ei.jobNumber = oo.jobNumber AND ei.jobNumber = oo.jobNumber
AND ei.arrivalDate BETWEEN '01/01/2011' AND '12/31/2011'
.. but I don't believe it's working. Can someone tell me how I can fix my code in order for it to give me the results I'm looking for.