asked on

Help writing t-sql statement checking for a match in tables

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...

SELECT     ei.jobNumber
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'

Open in new window

.. 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.

Thanks!

Paul Jackson

try :

SELECT     ei.jobNumber
FROM         eventInformation AS ei INNER JOIN
                      onlineOrder AS oo ON ei.jobNumber = oo.jobNumber AND ei.jobNumber = oo.jobNumber
                      AND (ei.arrivalDate >= '01/01/2011' AND ei.arrivalDate <= '12/31/2011')

Open in new window

cdemott33

ASKER

Tried it... but it gives me the same result. I'm reading about sub-queries. Would a subquery work in my case?

ASKER CERTIFIED SOLUTION

ICG

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Anthony Perkins

>> but I don't believe it's working. <<
So what about it is not "working"?