From: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | DESIGN OF A SELECT QUERY |
Date: | 2010-03-19 18:28:56 |
Message-ID: | f03943a01003191128m3bba6cd7s5694110342daf699@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I have designed a SELECT query by hand and by using a query designer and I
see a difference. Such a query includes 11 tables and I would like your
comments.
The designer result is somthing like:
SELECT fld1, fld2,...,fldn FROM tbl1
INNER JOIN .......
INNER JOIN .......
The query I wrote is as follows although I do not know if it works:
SELECT fld1, fld2,...,fldn FROM
tbl1
INNER JOIN...ON....
INNER JOIN...ON....,
tlb2
INNER JOIN...ON...
INNER JOIN...ON...,
tbl3
INNER JOIN...ON...
INNER JOIN...ON...
If you watch closely, the query generated by the designer includes only one
table in the FROM and all of the INNER JOIN's follow after it.
My design includes several tables in the FROM each one with its own INNER
JOIN's.
Is this valid?
Please advice.
Respectfully,
Jorge Maldonado
From | Date | Subject | |
---|---|---|---|
Next Message | richard terry | 2010-03-21 01:23:19 | Speed question - new view using preview view components |
Previous Message | Yves Moisan | 2010-03-19 18:28:30 | Re: Pseudo re-install on windows |