Re: [GENERAL] SELECT statement with sub-queries - Mailing list pgsql-general

From Michelle Konzack
Subject Re: [GENERAL] SELECT statement with sub-queries
Date
Msg-id 20170528185537.GK3646@cq58.hosts.tdnet.eu
Whole thread Raw
In response to Re: [GENERAL] SELECT statement with sub-queries  (ml@ft-c.de)
List 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

Attachment

pgsql-general by date:

Previous
From: Michelle Konzack
Date:
Subject: Re: [GENERAL] SELECT statement with sub-queries
Next
From: Neil Anderson
Date:
Subject: Re: [GENERAL] Help with terminology to describe what my software does please?