i have never used LEFT JOIN syntax in Oracle, actually I didnt know it works!