considering all the columns in a field
-
Hello friends, I having two table, one table havin only one fields. eg : Table A release rel1 rel2 rel3 I want to select datas from other table. table B release case ID rel1 a 1 rel1 b 1 rel2 a 2 rel3 c 3 I want to select the cases and ID from table B where release is all the datas present in TAble A. I can build the query to get case and ID. Actually i need the query for another purpose. I used below query SELECT cases, ID FROM TAble B WHERE release IN(Select release from TAble B) this query is very slow for my purpose The query should link both the table Please help me to opimise the query Regards Jishith
-
Hello friends, I having two table, one table havin only one fields. eg : Table A release rel1 rel2 rel3 I want to select datas from other table. table B release case ID rel1 a 1 rel1 b 1 rel2 a 2 rel3 c 3 I want to select the cases and ID from table B where release is all the datas present in TAble A. I can build the query to get case and ID. Actually i need the query for another purpose. I used below query SELECT cases, ID FROM TAble B WHERE release IN(Select release from TAble B) this query is very slow for my purpose The query should link both the table Please help me to opimise the query Regards Jishith