EXEC SQL                                            
 
   SELECT                                         
      A.EMP_ID 

      ,B.WAGE                                     
    FROM                                            
      Table1 A,                                    
      Table2 B                                 
    WHERE                                           
      A.EMP_ID     = 100001                  
    
END-EXEC.    

This is an example of a simple join query

EXEC SQL

SELECT A.EMP_ID, B.WAGE
FROM Table1 A,  Table2 B
WHERE A.EMP_ID = B.EMP_ID


AND A.EMP_ID = 100001
END-EXEC.