Automate

 View Only

  • 1.  Outer Joins In WInshuttle Query

    Posted 12-08-2021 04:06
    Good Day.

    I am using winshuttle query and  would love to prform outer joins on tables. Cuurently, i have to export data to MS access before i can perform outer joins but i would love create queires in one system. Please assisst me on how i can incorporate all types of table joins, other than inner joins, i nwinshuttle query.

    Regards,

    Nkosinathi B. Sithole

    ------------------------------
    Nkosinathi Sithole | Master Data Officer
    THE ROYAL SWAZILAND SUGAR CORPORATION | +26878253987
    ------------------------------


  • 2.  RE: Outer Joins In WInshuttle Query

    Posted 12-08-2021 04:37
    hi Nkosinathi,

    There is a max of 1 left outer join in a query.
    A detailed documentation can be found here: https://docs.winshuttle.com/studio-en-12-1-x-online-help-studio-w-connect/12/create-joins-between-tables.htm

    best regards, jan

    ------------------------------
    jan ketele | Sr engineer release mgt
    Xeikon Manufacturing NV | +3234431875
    ------------------------------

    Original Message


  • 3.  RE: Outer Joins In WInshuttle Query

    Posted 12-08-2021 04:49
    Hi Jan.

    Thanks  a lot. you just saved my job.

    Regards,

    Nkosinathi B. Sithole

    ------------------------------
    Nkosinathi Sithole | Master Data Officer
    THE ROYAL SWAZILAND SUGAR CORPORATION | +26878253987
    ------------------------------

    Original Message