Module: People (Payroll)

Using 4GL, how would I filter a list of Positions to only list positions that are currently vacant. The Positions are in a different table tot the Contracts table.

I.e. the 4GL equivalent of this SQL statement:

SELECT
      p.COD
      , p.DES
FROM
      SEED.POSTE p
      LEFT OUTER JOIN SEED.EMPLOCTR c ON c.POT = p.COD
WHERE
      c.POT IS NULL

So far I was able create a Link with the above two tables, but don't know how to Filter on 'IS NULL'?

And, if a Link is the way to go, how would I filter the Table to only list the positions currently in the Link (INNER JOIN the above Link to the Table).

I don't want to iterate through the positions as some companies could have many thousands of positions and there would be an undesired wait to generate the list.