Which of the following statements is true :
inner join and intersect are same
left join and union are same
inner join when used with distinct can simulate intersect
inner join and union are same