I am not sure that is a "SELECT/JOIN" problem but I really don't know how to formulate the question. Perhaps you could suggest a better title
I have a table (table-a) with a list of items, I Want to associate the information of table-B.col2 when it is equal to "1"
What query should I write?
Table A Col1 AAA BBB DDD EEE AAA 1 Table B =====> BBB Col1 Col2 DDD 1 AAA 1 EEE AAA 2 BBB 2 CCC 1 CCC 3 DDD 1 FFF 1