i am trying to fetch value from two tables of mysql database with same column name.now i am in trouble to specify column,means in two tables i have same column named contact\_name.I have to contact name from both tables.i can't understand how can i identify that contact name come from which table..please help.

My query is

```
$wpdb->get_results( "SELECT * FROM tbl_ratings,tbl_providers,tbl_members where tbl_ratings.provider_id=tbl_providers.provider_id and tbl_ratings.member_id=tbl_members.member_id" );

```

In both tbl\_providers and tbl\_members i have to fetch contact name saperatly.thanx in advance.