Can somebody help me with below sql query. It is showing an error and probably it is because of brackets. Thanks!
Error is: Syntax error (missing operator)
Code:select clientt.clientid,loant.loanid from (clientt inner join loant on clientt.clientid=loant.clientid) inner join schedulet s1 on loant.loanid=s1.loanid left join (SELECT pay.loanid, pay.paiddate FROM paymentt AS pay INNER JOIN (SELECT max(paymentid) AS id FROM paymentt GROUP BY loanid) AS [max] ON pay.paymentid=max.id) AS t ON t.loanid=s1.loanid