BuddyPress.org

The “*” after the SELECT statement says that you want to return all the fields of all the records in the table named {$bp->activity->table_name} that meet the search specifications. It does not mean select all tables. Therefore, for each row of the table that meets the requirements of the query, all the fields (columns) in that row will be returned in the recordset.

http://www.w3schools.com/sql/default.asp