Need a MySQL query developed to create a report for a Joomla based website using a catalog of products. Need query developed to select and join data from multiple tables and columns and display in a 14 table format/report.
A working query is all that is needed to produce the results as specified.
i.e stock number, make, model, ex owner, buyer, buyer name, salesman, sell price.
Tables and database structure already done, just need the query to generate the report.