Mehrere Varianten:

https://www.ibm.com/docs/en/i/7.1?to...ble-using-like
https://www.ibm.com/docs/en/i/7.1?to...table-using-as
https://www.ibm.com/docs/en/i/7.1?to...ed-query-table