The condition
and table.item = 'laptop' and table.item = 'Desktop'
says: I want all rows where the column item has the value 'Laptop' and
*at the same time* has the value 'Desktop'
Which clearly cannot be the case (a column can only have a single value)
So you need to join all "Laptop" rows to all "Desktop" rows to get
what you want.
why not use OR ?
... AND (table.item = 'laptop' OR table.item='Desktop') ...
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
