How can we help you today? How can we help you today?

Multiple FROM Clause inserted

Start with the following SQL:-
SELECT 
FROM [Categories]
FROM [Categories]

Now if you add fields you get a new FROM clause for every field. I added 2 fields and got 2 more from clauses.
SELECT [Categories].[CategoryID], [Categories].[CategoryName]	
FROM [Categories]	
FROM [Categories]
FROM [Categories]
FROM [Categories]
sangha
0

Comments

2 comments

  • Tilman
    Hi,

    Actually, I get an exception when i try that, but i suppose that is just as wrong :?

    Regards,

    Tilman
    Tilman
    0
  • sangha
    You get unhandled exception in SSMS.
    In Query Analyzer you get Multiple FROM Clause that I mentioned.
    sangha
    0

Add comment

Please sign in to leave a comment.