LifeinAsia - 3:44 pm on Sep 13, 2010 (gmt 0) If there's no found record in table 1 but there *is* one in table2, it will return a record. I believe that would be a RIGHT JOIN.