Post reply

A Virtual FROM Source

  • February 2, 2022 at 12:00 am

    #3969933

    Comments posted to this topic are about the item A Virtual FROM Source

  • February 2, 2022 at 9:30 am

    #3979928

    I'm afraid I take issue with the question.  I answered CTE because a CTE is neither a table nor a view and

    SELECT * FROM MyCte

    is perfectly valid.

  • February 2, 2022 at 2:03 pm

    #3980003

    Right, a CTE can dynamically construct a table the same as a VALUES clause.  It wouldn't be nice for very many rows, though -- but that wasn't the question :).

  • February 2, 2022 at 2:10 pm

    #3980029

    The question was "I want to get some data in a SELECT statement, but I don't have a table or view that matches my needs. What can I put into the FROM clause that will let me specify the data I need?"  A CTE is neither a table nor a view.  It might resemble one, but it isn't one, otherwise it would be called a table or a view.

  • February 2, 2022 at 2:34 pm

    #3980044

    I'm agreeing with you :).

  • February 2, 2022 at 2:39 pm

    #3980045

    Cool, sorry - I misread your comment ;¬}

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply