query results to list

Seeking SQL tip(s) for getting customer_no query results into a list (only if it's an efficiency improvement over copying over to csv and importing). 

Thanks, 

John

Parents
  • There is also always the "Show Query" option for a manual edit list right there in Tessitura.  But obviously that only works for queries that can be simply written in a single SELECT statement.  For more complex needs, the solution Nick mentioned is better.  But if you can manage to get it into a simple list, it does work well for beating the CSV/import option.

Reply
  • There is also always the "Show Query" option for a manual edit list right there in Tessitura.  But obviously that only works for queries that can be simply written in a single SELECT statement.  For more complex needs, the solution Nick mentioned is better.  But if you can manage to get it into a simple list, it does work well for beating the CSV/import option.

Children