Re: [GENERAL] SELECT statement with sub-queries

Поиск
Список
Период
Сортировка
От Michelle Konzack
Тема Re: [GENERAL] SELECT statement with sub-queries
Дата
Msg-id 20170528185537.GK3646@cq58.hosts.tdnet.eu
обсуждение исходный текст
Ответ на Re: [GENERAL] SELECT statement with sub-queries  (ml@ft-c.de)
Список pgsql-general
On 2017-05-28 20:19:59 ml@ft-c.de hacked into the keyboard:
> Hallo,
>
> SELECT *
> FROM products
> WHERE exists
>      (SELECT categories.cat FROM categories WHERE
>      categories.serial==products.category);

This does not give an error but does nothing

> or
> SELECT * FROM products
> WHERE category IN
>       (SELECT categories.cat FROM categories);

This give an error

See previously mail for what I want to archive


--
Michelle Konzack        Miila ITSystems @ TDnet
GNU/Linux Developer     00372-54541400

Вложения

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

Предыдущее
От: Michelle Konzack
Дата:
Сообщение: Re: [GENERAL] SELECT statement with sub-queries
Следующее
От: Neil Anderson
Дата:
Сообщение: Re: [GENERAL] Help with terminology to describe what my software does please?