Hello my friends. I have been trying to get a query to work this morning and it has not been easy. I was wondering if the problem may be that I am trying to JOIN two resident tables. Is this even possible? Thanks.
There is no problem to join two resident tables, but once they are joined, you'll have all the records in one table, so you have to drop the other table. In the example, you have table A, but once you have it you must:
DROP TABLE NEW_PO.
Then, you left join A with Resident IPPOHDR_DATA. Here, you don't need to put : before the LOAD, because the data will be automatically concatenated to A. After this, you can Drop the table IPPOHDR_DATA;
Remember that if none of your fields has the same name, the Left join will result none of your fields joined.