I have two tables - each with a shared field name memberID.
The members2 table gives info about members (name, address..) and has memberID a Key field.
The bank_cheque_listing table records transactions and has a memberID field - which is not a key field as memberID will reoccur whenever a member makes more than one transaction.
I need a query which will give me a listing of all transactions - each row of the listing containinng information about the nature of the transaction and also information about the member involved in the transaction.
I have tried creating a query using an INNER JOIN approach - but get an error reporting that no value was given for one or more parameters.
Can someone take a look at my query and tell me if I am on the right track here ?
Many thanks in advance;
<cfquery name="recordset_banklisting" datasource="Office">
INNER JOIN members2
ON bank_cheque_listing.memberID = members2.memberID
ORDER BY bank_cheque_listing.cheque_paydate