I have a query
I have 2 tables
table1(ocno [int],Productcategorycode [int])
table2(targetno [int],productcategorycodes [string]
field productcategorycodes is comma seperated
Now i want to write query fetching records matching Productcategorycode [int](first table)
with ,productcategorycodes [string](second table)
for exampe field productcategorycode value is '1'
Productcategorycodes value '1,2'
Query will display as oc123,1,targetno1,1
please help me
Thanks
Chandran