Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?
I’m not sure why you want to ban JOIN as its fairly essential to SQL. It’s like banning function calls in a functional language. A good way to solve this is to create a result set containing the ids you want to return and join with it. Here’s one way to do it: SELECT Table1.* … Read more