LEFT JOIN SQL SELECT ACTIVE, PERIOD, "R_ID", "R_NAME" FROM TableB where ACTIVE = 'Y';
// Now I have another table TableC. Need to combine string column R_NAME of Combo_Table1 with TableC's string column CODE // Also need to convert R_NAME string to uppercase // TableC has columns ID,CODE,MEANING and COMMENTS
// The below statement doesn't work. Getting syntax errors plus not sure how to combine a previously loaded table with another table using a WHERE clause.
Thanks for the reply. This was very helpful. I was able to connect TableC with Combo_Table1 with what you suggested.
The only minor change I did was I used RESIDENT. This is because the TableC is a huge table and I needed to restrict it with certain type. Somehow when I tried to use WHERE clause in the LOAD statement, it gave me syntax error. So I had to load specific rows of TableC into TempTable first.
********************************************* TempTable: LOAD ID, CODE,MEANING, COMMENTS; SELECT ID, CODE, MEANING, COMMENTS FROM TableC where LOOKUP_TYPE = 'T' ;
LEFT JOIN SQL SELECT ACTIVE, PERIOD, "R_ID", Upper( "R_NAME" ) as R_NAME FROM TableB where ACTIVE = 'Y';
TableC2:
Load ID, Upper(CODE) as R_NAME, MEANING, COMMENTS RESIDENT TempTable;
******************************************* I have one question : Is it possible to combine columns of both the Combo_Table1 and TableC2 and load into one final table ? Both the Combo_Table1 and FinalTable are logically connected thru R_NAME column but I need to have only one table "FinalTable" from which I can select all the columns. I tried using Load in different ways and not getting the results.
