Reformat SQL issue

roger-u posted 1 year ago in General

I had this as part of a longer SQL statement: LEFT JOIN ww_paynotes y ON p.semail = y.semail

but after using the Reformat SQL it becomes: LEFT JOIN ww_paynotes Y ON p.semail = y.semail

the alias letter y becomes uppercase - which can cause an error on Databasesdepending on their case sensitivity

it only seems to happen with the alias letter y e.g. LEFT JOIN ww_paynotes w ON p.semail = w.semail if not altered


Please login to leave a reply, or register at first.