SQL Editor

Question

I am trying to run a query using SQL Editor.  Why does SQL Editor rearrange all my filters?

Thanks

alexnajm · Answer

I'm not sure I understand - is it affecting your result? If anything the new rearranged filters look a little cleaner...

KTN · Answer

Query entered:

WHERE

((AL4.dlr_cd LIKE '60606%' 
    AND CAST  (AL3.rdte AS DATE) BETWEEN '01/01/2025' AND '04/15/2025'
   ))  and
    (AL2.rorderno = AL3.rorderno 
    AND AL2.rorderno = AL6.ro_num
    AND AL3.rorderno = AL6.ro_num
    AND AL2.rdlrno = AL3.rdlrno 
    AND AL2.rdte = AL3.rdte)
    AND AL4.dlr_cd = AL3.rdlrno
    AND AL3.vvin = AL5.vin
    AND AL2.RID = AL1.RID

Alteryx update query:

where AL2.rorderno = AL3.rorderno
and AL2.rorderno = AL6.ro_num
and AL3.rorderno = AL6.ro_num
and AL2.rdlrno = AL3.rdlrno
and AL2.rdte = AL3.rdte
and AL4.dlr_cd = AL3.rdlrno
and AL3.vvin = AL5.vin
and AL2.rid = AL1.rid
and AL4.dlr_cd Like '60606%'
and Cast(AL3.rdte as Date) Between '01/01/2025'
and '04/15/2025'

abacon · Answer

Can you post a screenshot of your issue?