I have a project in my MySQL class, and for this project I chose my game library. The query that I am using is to find which games were developed in-house, that is where the developer is the same company as the publisher. I have tried multiple queries, but seem to be getting caught up on using column names to join the table rather than the values in the column being equal. I will describe the tables and list some queries I have tried without success. I think the issue could be resolved by using an IN but I am not sure where I should start with that. Any help would be greatly appreciated!

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.