In Domo Workbench select column, * not returning data

BrianM
BrianM Member
in Workbench

I'm new to Domo and Oracle SQL having worked in MS SQL Server until recently. In Domo workbench 'Select column, T.* from Table T' doesn't return any rows of data in the preview window. 'But Select column from Table T' and 'Select T.* from Table T' both do return rows for the preview. I thought my issue might be PL/SQL related but the use of the alias should work in PL/SQL as it does in T-SQL form the posts I've been able to find. Any help on what I'm missing in the syntax translation would be appreciated.

Tagged:

Best Answer

  • ggenovese
    ggenovese Coach
    Answer ✓

    Just a guess, but could it be that you have duplicate column names? Instead of 

    SELECT column, T.* FROM TABLE T

    can you try 

    SELECT column as uniquely_named_column, T.* FROM TABLE T

Answers

  • ggenovese
    ggenovese Coach
    Answer ✓

    Just a guess, but could it be that you have duplicate column names? Instead of 

    SELECT column, T.* FROM TABLE T

    can you try 

    SELECT column as uniquely_named_column, T.* FROM TABLE T
  • BrianM
    BrianM Member

    That solved the issue. Thanks for the help!

Categories