Skip to main content
Question

Can we compare 2 table column in pql in casewhen statement?

  • Aug 30, 2022 1:32 AM UTC
  • 1 reply
  • 43 views
Level 7

Eg: casewhen table1. Column1 = table2. Column2 then 1 else 0 end.

Will this give accurate result or any way we can compare 2 tables to calculate the result? ​

    1 reply

    Level 12

    Hmmmm..... I guess that will only work reliable if you have a 1:1 relationship between table1 and table2

     

    Community Code of ConductAccessibility statement