* 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..
>
> main
> id entity_name ...
>
> fof
> id_fof id information_sent ...
>
> pub
> id_pub id information_sent ...
>
> etc.
>
> 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 >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
