Federico Bobbio wrote:

>
> As i said i'm not an experienced user so i'll tell you how i'm working
> with SQL. For example i have an Employeers table and they hava Phones
> (table) and Addresses (table) and when i need to get the data i open a
> connection to get the info from the Employeers table, inside of this
> connection i open another for the phones and another for the
> addresses, is this as bad as it sounds? :P
> The querys are like "SELECT <COLUMN_NAMES> FROM <ONLY_ONE_TABLE> WHERE
> EMPLOYEER_ID = X", this is just an example, there are no more than 10
> or 12 columns in the bigger tables
>

Err, maybe you should find an introduction to SQL. You don't need
a connection per table, you need a JOIN.

select e.name, a.address, p.phone
from employees e
join adresses a on e.id = a.e_id
join phone_numbers p on p.e_id = e.id


Good luck,


Ann