Try query below and let us know if it solves the problem and any other issues you are facing related  select id, st.value street, ph.value phone from table, table.result st, table.result ph where st.key=’street’ and st.value='abc' and ph.key=’phone’ and ph.value='123'   ... View more