i have been trying to write a query which will return all clients and the related tables so that i can then allow the users to filter in a php website.
at moment i tried this but returned no results even though there are records:
SELECT * FROM clients JOIN buytolet on clients.ClientID = buytolet.clients_ClientID JOIN protection on clients.ClientID = protection.clients_ClientID
to further the query i need to join lenders name to the protection table so they can filter by lender name etc, however i just want to create the joins so i can then create the filter.
can anyone help please?