Query troubles

[dsundy2003]

I should know this, but alas, I am stuck.
I have 2 tables. One big one, and one small one. The big table has customer #, contract # and equipment description. The smaller table has just customer & contract #.
I want to write a query in access thats gives me all the customer, contrac numbers & description where all the customers & contracts in the one table equals the other.

I think my hassle is that cusomer number and contract number are 2 fields. If I could concatenate them into one field, then my lookup would be eisier.

How would I write a query (not using the concatenate option ) ?

Thanks

D

 

[Philem]

Hullo. Aside from the fact that you should think about normalizing your structure try this:

SELECT BIG.[Customer#], BIG.[Contract#], BIG.EquipDescr
FROM BIG INNER JOIN SMALL ON (BIG.[Contract#] = SMALL.[Contract#]) AND (BIG.[Customer#] = SMALL.[Customer#]);

HTH

P