Try:left OUTER join.You need OUTER, depending on the results you are trying to obtain,the direction you are joining.(INNER) JOIN: Returns records that have matching values in both tablesLEFT (OUTER) JOIN: Returns all records from the left table, and ...