Knowledge Drop

Which order do I write my join in sql_on?


Userlevel 5
Badge
  • Looker Staff
  • 173 replies

  

Last tested: Sep 2020

 

It doesn't matter. According to docs, you can write the join in any order. Thus these two are equivalent:

sql_on: ${order.user_id} = ${user.id} ;;
sql_on: ${user.id} = ${order.user_id} ;;

 

This content is subject to limited support.                


0 replies

Be the first to reply!

Reply