SQL is not maintaining the direct field toward the field comparison currently within the WHERE clauses. The SOAP API also does not allow the IN clause within the SOQL queries. Looks like it is a bit crazy, however it is 95 percent about Salesforce.
If you want to unleash your potential in this competitive field, please visit the Salesforce Training page for more information, where you can find the and salesforce Interview Questions FAQ's and answers as well.
For more updates on the latest courses stay tuned to HKR Trainings.