Skip to Content
0
Former Member
Dec 27, 2007 at 12:15 PM

join of 2 tables.

131 Views

Hello Friends,

I'm unable to do a simple join thing .. I'm joining AUSP ,KLAH tables . i'm taking OBJEK,ATINN,KLART,ATWRT from AUSP table and KLART ,CLASS from KLAH ..

finally i need OBJEK ,ATINN,KLART,CLASS, ATWRT. ok .

the thing is while i'm joining the two tables ..suppose i have 5 classes for a single class type .and one material will contain only one class.

in result its giving for one material one class type , 5 classes , and one characteristic five times.

how can i find that for that particular material ,that which class we used .. .. so please friends anyone one knows solutions... please let me know..

i don't want to hot code it anywhere.....so ... please give me a solution .

thanks& regards

lavanya.a