MySQL Forums
Forum List  »  Install & Repo

Rewrite of a Old MYSql Statement
Posted by: Stephen Lilly
Date: April 14, 2015 12:53PM

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

Options: ReplyQuote


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.