Show only rows where there is a full match

skoTner · #1 (**permalink**) 03-08-10, 09:23

Let say I have this table:

id|item|string|value

With the following rows:

1|1000|Press|112
2|1001|Press|112
3|1001|ET|27

What query will return only the item 1001 because that is the only record which match all the values of the string column? And then if I insert a new row for item 1000 with ET and 27 it should also show.

r937 · #2 (**permalink**) 03-08-10, 09:50

Code:

SELECT t.id
     , t.item
     , t.string
     , t.value
  FROM ( SELECT item
              , string
           FROM daTable
         GROUP
             BY item
              , string
         HAVING COUNT(*) > 1 AS d
INNER
  JOIN daTable AS t
    ON t.item   = d.item
   AND t.string = d.string

skoTner · #3 (**permalink**) 03-08-10, 10:28

skoTner · #4 (**permalink**) 03-08-10, 10:32

I'm trying by the way:

Code:

SELECT * FROM product_table
JOIN filter_table ON product_table.id = filter_table.product_id
JOIN session_table ON session_table.value = filter_table.value AND session_table.string = filter_table.string
GROUP BY product_table.id

Works, but gives me all products within the filters.. when I add filter no 2 and so on it still gives me all

skoTner · #5 (**permalink**) 03-08-10, 10:37

I'm trying by the way:

Code:

SELECT * FROM product_table
JOIN filter_table ON product_table.id = filter_table.product_id
JOIN session_table ON session_table.value = filter_table.value AND session_table.string = filter_table.string
GROUP BY product_table.id

Works, but gives me all products within the filters.. when I add filter no 2 and so on it still gives me all

Internet Services

Web Development

Digital Marketing

Consumer Tech