Infor interview question

SQL, Basic questions over DML, JOIN and subqueries?