Re: ok, I have another select for ya

Поиск
Список
Период
Сортировка
От
Тема Re: ok, I have another select for ya
Дата
Msg-id Pine.LNX.4.30.0108101534140.27363-100000@commandprompt.com
обсуждение исходный текст
Ответ на ok, I have another select for ya  (Jeremy Hansen <jeremy@xxedgexx.com>)
Список pgsql-general
On Fri, 10 Aug 2001, Jeremy Hansen wrote:
>bug_id is a field present in all three of my tables.
From my earilier question, I understand I need to use joins to avoid a
>cartesian join.
>This is my question, how can I do a:
>
>select * from summary,env_info,plat_info where summary.subject like
>'%test1%';
>properly?

I'd recommend using the JOIN syntax to create your set, and then applying
a WHERE clause to that set. For example:

SELECT * FROM summary s
         INNER JOIN env_info e ON (s.bug_id=e.bug_id)
         INNER JOIN plat_info p ON (s.bug_id=p.bug_id)
         WHERE s.subject LIKE '%test1%';

That way you're only doing the WHERE on the new set.

Note that the letters following the table names are used later for the dot
notation of the columns. This just makes it a bit more readable (to my
eye).



Regards,
Jw.
--
jlx@commandprompt.com
by way of pgsql-general@commandprompt.com


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

Предыдущее
От: Jeremy Hansen
Дата:
Сообщение: Re: ok, I have another select for ya
Следующее
От: Allan Engelhardt
Дата:
Сообщение: How to change default time display format (and buglet?)?