Search Postgresql Archives

Re: SELECT statement with sub-queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On 28.05.2017 20:19, ml@xxxxxxx wrote:
Hallo,

SELECT *
FROM products
WHERE exists
      (SELECT categories.cat FROM categories WHERE
      categories.serial==products.category);
       categories.serial = products.category);  -- one equal sign

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

On 28.05.2017 19:03, Michelle Konzack wrote:
Hello *,

I try to get columns from my database with a singel SELECT, but I stuck.

I have 3 tables like:


1)  categories (serial,cat)

2)  manufacturers (serial,m_name)

3)  products (serial,category,manufacturer,p_name)


where the "category" and "manufacturer"
are numerical IDs from the two tables above.

So I like to replace the numerical IDs with the appropriated values,
mean

SELECT * FROM products WHERE category IN
     (SELECT categories.cat FROM categories WHERE
     categories.serial==products.category);

But I get:

ERROR:  operator does not exist: integer==integer
LINE1: ...gories.cat FROM categories WHERE categories.serial==products.category);
                                                              ^
Hmm, "serial" is an "integer" and the "category" and "manufacturer" too.

So whats wrong with it?











--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux