Preguntas de entrevista para el cargo de CIB-Core Java Developer en JPMorganChase

Technical question were quite basic now that I think of it. One question asking me to use one single SQL query to retrieve information from two related tables given only one key information was something I did not prepared for since I only have very basic knowledge of it and have not used it for a while. The technical interviewer kindly informed me that I could use join table technique.