Solved

Error in my FROM Statement but dont know where ??

Posted on 2008-09-29
4
164 Views
Last Modified: 2010-03-20
Hi all,

can someone run their eyes over this. i'm getting the following error message:

Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.  
 
The error occurred in C:\Inetpub\wwwroot\woodbits\index.cfm: line 1
 
1 : <cfquery name="GetRecProducts" datasource="#request.dsn#" username="#request.dsn#" password="#request.dsn#">
2 : SELECT tbl_prdtcategories.category_ID, tbl_products.product_Name,
3 : tbl_products.product_Description, tbl_products.product_Archive,
 

the code is :

<cfquery name="GetRecProducts" datasource="#request.dsn#" username="#request.dsn#" password="#request.dsn#">
SELECT tbl_prdtcategories.category_ID, tbl_products.product_Name, 
tbl_products.product_Description, tbl_products.product_Archive, 
tbl_prdtimages.prdctImage_FileName
FROM tbl_products
INNER JOIN tbl_prdtcategories
INNER JOIN tbl_prdtcat_rel ON
tbl_prdtcategories.category_ID = tbl_prdtcat_rel.prdt_cat_rel_Cat_ID ON
tbl_products.product_ID = tbl_prdtcat_rel.prdt_cat_rel_Product_ID
INNER JOIN tbl_prdtimages ON
tbl_products.product_ID = tbl_prdtimages.prdctImage_ProductID
WHERE tbl_prdtcategories.category_ID=6
AND tbl_products.product_Archive=0
</cfquery>

Open in new window

0
Comment
Question by:bede123
  • 2
  • 2
4 Comments
 
LVL 17

Expert Comment

by:Daniel Reynolds
ID: 22597821
you are missing the ON statement condition for the first inner join
FROM tbl_products
INNER JOIN tbl_prdtcategories   <ON   blah>
0
 
LVL 1

Author Comment

by:bede123
ID: 22598358
thanks. i dont suppose you can help me some more. this code was written for me so i'm really not sure what exactly should go after the ON


INNER JOIN tbl_prdtcategories

0
 
LVL 17

Accepted Solution

by:
Daniel Reynolds earned 500 total points
ID: 22598424
I have modified the query a bit and moved some join info around.

This should be what the author intended.

SELECT tbl_prdtcategories.category_ID
    , tbl_products.product_Name
    , tbl_products.product_Description
    , tbl_products.product_Archive
    , tbl_prdtimages.prdctImage_FileName
FROM tbl_products
INNER JOIN tbl_prdtcategories ON tbl_prdtcategories.category_ID = tbl_prdtcat_rel.prdt_cat_rel_Cat_ID
INNER JOIN tbl_prdtcat_rel ON tbl_products.product_ID = tbl_prdtcat_rel.prdt_cat_rel_Product_ID
INNER JOIN tbl_prdtimages ON tbl_products.product_ID = tbl_prdtimages.prdctImage_ProductID
WHERE tbl_prdtcategories.category_ID=6
AND tbl_products.product_Archive=0


0
 
LVL 1

Author Comment

by:bede123
ID: 22598973
great. thank you very much indeed.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Access 2010 Query Syntax 5 30
possible to record changes (trigger I think) msql 11 34
SQL NULL vs Blank 26 35
export sql results to csv 6 34
Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question