Hi Kenneth,

Thanks for the reply. The problem i have is, there will be a multiple contact nos selected from the input parameter. All the contact nos will use in the WHERE clause to select records from TableC and return the result. The contact no selected from table B can be 3 and up to 16 nos.How this can be done on the join table? Is that i need a way to loop thru and compare WHERE condition in order to select all correct records from TableC?

Please correct me. I new to programming. Thanks.