Can anyone help me with this query, I am trying to load a report accessing a MS SQL database.
Please help me, thanks in advance.

Code:
Keyword not supported: 'select (customerlist.lastname & ', ' & customerlist.firstname & ' ' + customerlist.middlename) as customername, salesorder.invoiceno,salesorder.barcode, salesorder.itemqty, salesorder.itemprice,products.description, (salesorder.itemqty * salesorder.itemprice) as totalpurchase from customerlist inner join salesorder on salesorder.customerid'.