I would like to join 2 select list 9 with (different structure) into a single list. what should i do.

if yes, can you pls give me an example?

tq!

And how exactly would you like to join 2 different structures?
Could you be more precise what you want?

there are 2 table

TABLE NAME :OE.CSSALES2
STRUCTURE : SALES.NO, ITEM.CODE (THIS FIELD IS MULTIVALUE)

TABLE NAME :IV.MASTER
STRUCTURE : ITEM.CODE, S.CTGY (THIS FIELD IS MULTIVALUE)

REQUIRED FORMAT (AFTER JOINT)

SALES.NO ITEM.CODE S.CTGY


PLEAE HELP ME, IT SO URGENT!

Hi Hew,

This could be what you may be looking for.

select sales.no, item.code, s.ctgy
from oe.cssales2 a, iv.master b
where a.field = b.field and ...

You need to specify the equality relation for the join to work properly according to your business rule.

Regards,
Shriyan

thanks alot.

but I would to to use tcl command rather than using the SQL statement(because iam using the uniobject). can i use tcl to join all this table together?