Results 1 to 5 of 5

Thread: join 2 list

  1. #1
    Join Date
    Dec 2003
    Posts
    26

    Question Unanswered: join 2 list

    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!

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    And how exactly would you like to join 2 different structures?
    Could you be more precise what you want?
    rws

  3. #3
    Join Date
    Dec 2003
    Posts
    26
    Originally posted by Roelwe
    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!

  4. #4
    Join Date
    Nov 2003
    Location
    Mumbai, India
    Posts
    92
    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

  5. #5
    Join Date
    Dec 2003
    Posts
    26
    Originally posted by vpshriyan
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •