[url removed, login to view] complete a mysql query on Virtuemart tables to produce desired csv file output.
2. The mysql query produced must run in Navicat 8 mysql for windows.
Job has 6 Tasks - see attached file - [url removed, login to view], where the attachment contains:
- required alias field names and desired csv format for query output
- VM database equivalent fields & tables (discovered so far)
- the 6 task details, listed under the field the task applies to.
Also need query to be commented so I can add "custom data" in right places & add extra fields easily should they ever be needed. Comments must take account of any joins needed (i.e. how to add joins).
solid mysql query creation
ability to concatenate, x-ref, append, identify (a few) fields in DB, & produce joins where data resides in different tables.
Provide coherent comments on code
I can provide DB login details to a Virtuemart example if this needed.
Attachment 2 - [url removed, login to view] - my attempt at part of the query - if it's of any use!
Priority: Fairly Urgent!