select a.* from pm1.g1 as a, pm1.g2 as b where a.e1 = 1100 and a.e1=b.e1
integer      string                                            
e1           e2                                                
1100         '1100'                                            
Row Count : 1
getColumnName  getColumnType  getCatalogName  getColumnClassName  getColumnLabel  getColumnTypeName  getSchemaName  getTableName  getColumnDisplaySize  getPrecision  getScale  isAutoIncrement  isCaseSensitive  isCurrency  isDefinitelyWritable  isNullable  isReadOnly  isSearchable  isSigned  isWritable  
e1             4              Transaction     java.lang.Integer   e1              integer            pm1            g1            11                    10            0         false            false            false       true                  0           false       true          true      true        
e2             12             Transaction     java.lang.String    e2              string             pm1            g1            50                    50            0         false            true             false       true                  1           false       true          true      true        
