Re(2): optimize sql

Поиск
Список
Период
Сортировка
От pgsql-sql@fc.emc.com.ph (pgsql-sql)
Тема Re(2): optimize sql
Дата
Msg-id fc.000f56720059cb84000f56720059cb84.59cc50@fc.emc.com.ph
обсуждение исходный текст
Список pgsql-sql
reedstrm@rice.edu writes:
>How does the output of the above differ from:
>
>SELECT name FROM office, office_application 
>WHERE code = office_code 
>AND active != 't';
>
>Without knowing the table structures (which tables to active, code, 
>and office_code belong to?) it's hard to suggest much else.
>
>Ross


The name and code fields belong to office table. While
office_code and active fields belong to office_application table.
The name field have duplicates and among the duplicates,
only one active field is TRUE. I just wanted to get name field
that has no TRUE active field. Any other idea? Thanks.

sherwin



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: optimize sql
Следующее
От: danny
Дата:
Сообщение: how to r/w blob field in php