Query 3 tables using SELECT * how do I do this, in one go

Hi,

I have 3 tables (table1, table2 and table3), that I need to select * query where name = 'abc'
The only common thing is name for the 3 tables.

I am not sure how to do this, can someone give some ideas.

Thanks