left join

[Fabio Bernardo]

Hi there... I have this situation:

table_A      table_B
id name     id   name
1   A          1     A 
2   B          2     B
3   C

If i run this statement :
SELECT table_A.* FROM table_A outer join table_B ON table_A.id=table_B.id
WHERE table_B.id is null
and I got:
id   name
3    C

But now i wanna use i join which i dont know, to results:
id    name
1      A
2      B

I mean the rows which are exactly the same.... is there a fast type of join
to make it?