Automate

 View Only

  • 1.  Query build from tables - join issue

    Posted 02-26-2026 13:05

    Hi - I don't seem to have the ability to change a join to an outer left join. Functionality always greyed out.

    I am a Query Data Dictionary Administrator

    image


    ------------------------------
    Renette Nienaber
    Mrd
    VIVO ENERGY SOUTH AFRICA (PTY) LTD
    ------------------------------


  • 2.  RE: Query build from tables - join issue

    Posted 02-26-2026 13:22

    found it :-)

    image


    ------------------------------
    Renette Nienaber
    Mrd
    VIVO ENERGY SOUTH AFRICA (PTY) LTD
    ------------------------------

    Original Message


  • 3.  RE: Query build from tables - join issue

    Employee
    Posted 02-27-2026 10:50

    Thanks for sharing, Renette. You got to it before I could. :)

    The defaults are pretty limited, as you can see. You can change the settings up to 25 tables and then check or uncheck options, as you have found.

    The documentation for that setting and other preferences is here: https://help.precisely.com/r/t/1016755376/2025-10-28/Automate-Evolve/pub/Latest/en-US/Automate-Evolve-User-Guide/Preferences?tocId=FRLj4oyKG7O1UgJtAMqOvw

    Best Regards,

    Sigrid



    ------------------------------
    Sigrid Kok
    *Precisely Software Inc.
    ------------------------------

    Original Message