single master record to multiple records 1

[evr72]

Hello,

I have two tables a sales table and a commissions table. In my sales table I have the following fields:

Salesrep, custnum, custname, itemnum, qty, price

In my commmission table I have the following fields

salesrep, custnum, itemnum, commprc

the problem that I have is that the commissions table has the base item number and the sales has the basenumber plus extra characters
for example:

Base Part Number	Sales Item could be
3000	              3000BK
	              3000BL
	              3000GR
	              3000WH
	              3000RD
	              3000YW
	              3000GR
	              3000

I am not sure how to go about building my query so I can matach the base item to all the items in the sales table.

 

[SkipVought]

hi,

from sales a, commissions b
where a.itemnum=left(b.itemnum,len(a.itemnum))

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[evr72]

SkipVough!!!

Thank you!!!! that worked!!