Left join tables

kev.mag

hi i want to output the information of a joined table.. i want to have a data with a query something like
"SELECT
tax.ID,
tax.STATUS,
tax.ERANGE,
tax.SRANGE,
tax_percentages.PERCENTAGE,
tax_percentages.TAX,
tax_percentages.FREQUENCY
FROM tax
LEFT JOIN tax_percentages
ON tax.TAX_ID = tax_percentages.TAX_ID"

how can i edit my codes to match this? thanks.

Ashbjorn

@kev.mag, your question is lacking so much information that the chances of getting a reply that would help you are very minimal and possible ignored by many viewing it.

Hope this helps,

allan

@kev.mag - As @Ashbjorn notes we would need more information. For example, are you using Editor's server-side libraries (PHP or .NET)? Or are you using something else? If something else, then your question is likely outside of the scope of DataTables since DataTables is a client-side library and your question is about how to execute SQL (presumably on the server-side).

Allan