Rewrite of a Old MYSql Statement
Hello
I have a MYSQL select statement which works fine with MySql 5.0, however isn't compatible with the latest version of Mysql - 5.6
Is it possible to rewrite to remove the "*" which I believe to be the problem
Any suggestions / assistance would be apprciated
SELECT `crmnow_pdf_fields`.pdffieldname AS name, `crmnow_pdfcolums_sel`.pdftaxmode AS taxmode, `crmnow_pdfcolums_sel` . * AS selected, `crmnow_pdfcolums_active`.position AS active, crmnow_pdf_fields.quotes_g_enabled AS group_enabled, crmnow_pdf_fields.quotes_i_enabled AS individual_enabled
FROM `crmnow_pdfcolums_sel`
INNER JOIN crmnow_pdfcolums_active ON ( crmnow_pdfcolums_active.pdfmodulname = `crmnow_pdfcolums_sel`.pdfmodul )
INNER JOIN crmnow_pdf_fields ON crmnow_pdfcolums_active.pdftaxmode = `crmnow_pdfcolums_sel`.pdftaxmode
WHERE pdfmodul = 'Quotes'
AND `crmnow_pdf_fields`.pdffieldname = 'Position'
Thank You
Subject
Written By
Posted
Rewrite of a Old MYSql Statement
April 14, 2015 12:53PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.