mysql - Stuck on access query -

mysql - Stuck on access query -

i have query have make, these specifications:

orders ready send out client address. these types of orders can identified because amount owing order less or equal 0 (if amount still left pay less zero, means have overpaid order can still shipped out), , order not marked sent out (sent out false). query should list of customer's information, including name, address , phone, , of order information, output should sorted city, , client lastly name.

this sql have query:

select tblcustomers.customerid, tblcustomers.lastname, tblcustomers.firstname, tblcustomers.addressline1, tblcustomers.phone, tblorders.orderid, tblorders.customerid, tblorders.numberofcds, tblorders.orderdate, tblorders.paymenttype, tblorders.amountpaid, tblorders.discount, tblorders.ordersent tblcustomers inner bring together tblorders on tblcustomers.customerid = tblorders.customerid;

when seek run query says "type mismatch in expression" how can prepare this?

one explanation datatype of customerid column in tblcustomers different datatype of customerid column in tblorders.

there's insufficient info provided diagnose further.

mysql sql database ms-access-2013