I have an PSQuery query I've written in Query manager (since I have to use that rather than write the thing in Java, which I'd prefer) and the query joins multiple tables. However, some of those tables represent optional data. That is, not every table that I reference has to have a row for the emplid I am using in PeopleSoft. How can I code a PSquery such that if a table that I am joining does not have a row, the query still succeeds overall, rather than failing because some optional table does not have a row? Thanks.
Ken
Ken
Comment