Skip to main content
Question

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

  • August 30, 2022
  • 1 reply
  • 12 views
P
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

    G
    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