Advertisement

04.29.2008 at 09:33AM PDT, ID: 23362626
[x]
Attachment Details

SQL error - FROM keyword not found where expected

Asked by jstubing in MS SQL Server

Tags: FROM keyword not found where expected

I'm writing a query to use in Data Junction.  Data Junction only reads one query, so I am having create virtual tables in my FROM statement rather than have have CREATE TABLE queries.  I think I have all my commas and ANDS in the right place, but I am still getting a "FROM keyword not found where expected error".  It mentions line 81, which is the last line of my query.

The SQL file is attached.  Any help would be greatly appreciated.Start Free Trial
Attachments:
[+][-]04.29.2008 at 09:41AM PDT, ID: 21463874

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.29.2008 at 11:17AM PDT, ID: 21464697

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: FROM keyword not found where expected
Sign Up Now!
Solution Provided By: Michelt
Participating Experts: 2
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628