how to write a sql query to merge two table and display it in ListView Control in asp.net?

I want to merge(JOIN) two tables based on some condition and display that in list-view control….
the problem is both the table contain the attributes with the same name “id”,”name” and “message” how to display these items separately in item-template….