To query many tables. - Mailing list pgsql-sql

From trebischt@freemail.hu (trebischt)
Subject To query many tables.
Date
Msg-id f391b602.0109111047.4735563b@posting.google.com
Whole thread Raw
List pgsql-sql
Hi,

I have to query many tables (about 18 tables) 
from a database to field a riport in HTML.
I can make the query and it works (I think), but it's a bit strange to
me.
The query looks like this:

select * from table1 f, table2 s, table3 t, table4 fo, table5 fi,
table6 si, table 7 se, table8 e, table9 n, table10 ten, table 11 el,
table 12 tw ...
where f.id=s.id
and f.id=t.id
and f.id=fo.id
and f.id=fi.id
and so on...

Is this the right way, or are there any better solution?
How do the professionals make that big queries?

Thanks in advance!

Regards,

Trebb


pgsql-sql by date:

Previous
From: "Jack"
Date:
Subject: array variables in pl/pgsql
Next
From: "datactrl"
Date:
Subject: array variable in pl/pgsql