I knew what are they, but my english was not good to explain clearly. I tried to explain what is difference between inner join and left join(such like inner is interesection, but left join will give u not joined result in left table and so on)