You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
select *
from setup.trans_bases t
join setup.hier_bases_total b on b.azienda=t.azienda
and b.idhier_bases=t.idhier_bases_start
and year(b.fine_validita)=9999
join setup.hier_bases_total b1 on b1.azienda=t.azienda
and b1.idhier_bases=t.idhier_bases_end
and year(b1.fine_validita)=9999
where t.idtrans_anag=7;
I can confirm, but I think it isnt an actual issue, maybe just an enhancement.
If you use () it gets indented:
SELECT*FROMsetup.trans_bases t
JOINsetup.hier_bases_total b ON (b.azienda=t.aziendaANDb.idhier_bases=t.idhier_bases_startAND year(b.fine_validita)=9999)
JOINsetup.hier_bases_total b1 ON (b1.azienda=t.aziendaANDb1.idhier_bases=t.idhier_bases_endAND year(b1.fine_validita)=9999)
WHEREt.idtrans_anag=7;
Sometimes code doesn't get indented at all.
For example, this valid Sql statement (MySql):
..after SQL Beautifier, remains the same.
My user preferences:
Sublime Text 3, build 3083.
Thank you!
The text was updated successfully, but these errors were encountered: