--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:

>
> 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
>

Thanks Ann! I knew that but i didn't know the performance differences
of the join and what i was doing, sorry if it was too stupid and if i
made you waste your time. I really appreciate your and Helen's help

Good luck!