* Petre Agenbag
> I'm trying to return from multiple tables, the records that have field
> "information_sent" between two dates.
> The tables are all related by means of the id of the entry in the main
> table, ie..
> id entity_name ...
> id_fof id information_sent ...
> id_pub id information_sent ...
> So, I tried the following join
> select * from main
You need to name all fields, and use aliases to rename the colliding names:
select main.*,fof.id fof_id,fof.information_sent fof_info_sent,
pub.id pub_id,pub.information_sent pub_info_sent,
...and so on.
<URL: http://www.mysql.com/doc/en/SELECT.html >