two tables displayed in one datatable

two tables displayed in one datatable

nokonoko Posts: 10Questions: 3Answers: 0

Is it possible to display information from two mysql tables in one data table. One called 'orders' & the other 'client_details' where orders.client_number=client_details.id. Is it possible ? when I try to join it gives me an error SQLSTATE[4200]: Syntax error or Access violation 1077 Not unique table/alias: 'orders'

This discussion has been closed.