Manhattan Associates interview question

sql left join queries java bug fix