Can Workbench queries support Common Table Expressions?

lauraanderson Domo Employee

December 2015 in Archive

Can Workbench queries support Common Table Expressions (CTE's)?

Are the CTE's supported dependent on the flavor of SQL database the user is connecting to?

 

Thanks!

 

0

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.

Sign In

Comments

• 

  kshah008 Contributor

  December 2015

  Hi all,

   

  Can anybody help @lauraanderson with their question?

   

  Thanks!

  0
• 

  Smu Domo Employee

  January 2016

  Hello @lauraanderson

   

  Workbench sends the query exactly as it's typed to the ODBC driver. So if the driver allows CTEs workbench should be able to handle it as well.

  0
• 

  kshah008 Contributor

  January 2016

  @lauraanderson, did Smu's reply help answer your question?

  0

This discussion has been closed.