let me try it this way HAHA.

Table 1 has 4 columns and the mock data looks like this...

1234 ABC TEXT 80

1234 XYZ...

I also have a table with the distinct values for the DESC column for every MASTER_ID which is structured as follow....

Not sure if you could use this table to get...

This is one table with 4 columns. COL1 = MASTER_ID, COL2 = SUB_ID, COL3 = DESC, COL4 = %

Each MASTER_ID has SUB_ID's... for each SUB_ID in the set of...

one issue I am seeing is that there are descriptions from other MASTER_ID's. each MASTER_ID has specific desc which should not be appearing in other MASTER_ID's

for example MASTER_ID '9876'...

Hi Alan,

Thank you for your response. There are 4 columns actually the 1234 is one column, ABC is another, then TEXT is another, and the PCT column is the...

I have a new twist...

If my table1 now looks like this..

create table #table1

(

ID CHAR(10),

SUB_ID CHAR(3),

TDESC CHAR(100)

...

Thank you! Looks like this worked!

I will try to clarify my question.

So I have two tables with the following sample data....

table1

12345 ABC TEXT

12345 ABC TEXT1

12345 XYZ TEXT

table2 contains distinct values for the...

Thank you for your help! I will give it a try and see how it goes. If anything I will try to figure out a way to better explain myself.

table2 contains the distinct value of each ID's desc. for example....

to clarify, i would need to compare table1 to table2, look through table1 ID's and for each ID insert a...

unfourtunatly i am unable to post this information... but hope this helps...

table1

(

ID CHAR(10)

SUB_ID CHAR(3)

DESC CHAR(100)

)

table2

(

ID CHAR(10)

DESC CHAR(100)

)

I would need to look through table 1 so that for every SUB_ID...

for example I have table 1 with 3 columns and table 2 with 2 columns I have ID column in both tables and a desc column in both tables. No...