Re: SELECT statement with sub-queries

From: Michelle Konzack <linux4michelle(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: SELECT statement with sub-queries
Date: 2017-05-28 18:55:37
Message-ID: 20170528185537.GK3646@cq58.hosts.tdnet.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2017-05-28 20:19:59 ml(at)ft-c(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Neil Anderson 2017-05-28 19:11:10 Re: Help with terminology to describe what my software does please?
Previous Message Michelle Konzack 2017-05-28 18:54:03 Re: SELECT statement with sub-queries