Hi Phil,

I seek your help on this.....

Please help me on this.

I have 3 tables

Table A:- Driver Table

CAT Code, Parttype, BasePartNo, LikePartNo

MCN, FLOORMAT, MCNW10, MCNW10**

MCN, FLRLNR, MCN444410, MCN4*4410

Table B:- Build Table

CAT Code, Parttype, BasePartNo, LikePartNo1, LikePartNo2... LikePartNo50

MCN, FLOORMAT, MCNW10, MCNW10TN, MCNW10GR,-,-

MCN, FLRLNR, MCN444410, MCN454410, MCN464410,-,-

Table C:-

Application Table

make, model, year, remarks , part#, remarks2, footnote_list

58, 747, 2003, L; Automatic Trans, MCNW10TN, 2.0L, E009

58, 747, 2002, Base; Automatic Trans, MCNW10TN, 2.0L, E009

Requirement is like this:- Retrieve Application field like make,model as in application table for Basepart and Like Part Nos.

Run comparison between basepart and like part No in application table and build Report which must contain if any mismatch In make model etc..

i.e make model,remarks.. etc for basepart is not equal to the make, model, remarks etc... for likepartnos

Attribute means: make,model,year etc.. make model year,Model,part#,application#,remarks2,remarks3

for eg:-

likepart Attributes--

63,6853,2010,Silverado1500,MCNW10GR,5155634,5.7L,Rear

likepart Attributes

63,6853,2011,Silverado1500, MCNW10TN,5155640,5.3L,back

BasePart Attribute

63,6853, 2010, Silverado1500,MCNW10,5155640, 5.3L, Rear

Here attributes for base part is correct and act as a reference, and if likepart contain other attributes it should appear in result.

Result

63,6853,2010,Silverado1500, MCNW10GR, 5155634,5.7L, Rear

63,6853,2011,Silverado1500, MCNW10TN, 5155640,5.3L, back

Make, model,year,remarks.... etc for base part number need to compare it with Make, model,year,remarks.... etc for likepartnumber in application table.

here application table contain the part which is present in either likepartnumber1,likepartnumber2... likepartnumber50 of Build Table

so the comparison is need to be done with application data like make,model.. etc for base partnumber

to the application data like make,model.. etc for likepartnumber in application table

Thanks a ton.... 🙂