Skip to Content
avatar image
Former Member

How to use "left outer join" in SQVI

Dear ALL ,

I want to match MARA materials with BOM material table (MAST,STPO)material or Routing material table (MAPL,PLPO) and I want the list of NONMATCHING material codes from SQVI.

How to get these items which do not match in 2 tables........?

I have to work with SQVI + EXCEL ( VLOOKUP ) in excel sheet.

Thanks...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 13, 2007 at 04:30 AM

    Kishore,

    After selecting the table join option, In layout mode enter the table names in Joined tables tab. Select the 2 tables using check boxex and select the join type like left inner and click on define condition. This would create a left inner join. Similarly carry out for the next 2 tables.

    Hope it is useful. If so reward your points.

    Regards

    Ram

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 13, 2007 at 08:06 AM

    I trird but the result output is same in both conditions i.e. with inner join and left outer join.

    Pl' give example.....

    Add comment
    10|10000 characters needed characters exceeded