Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tombino
Starting Member
26 Posts |
 Posted - 2007-05-29 : 02:12:32
|
| Hi,I have some issue with this query:sSQL1 = "SELECT tbl_Info_1.Infodata AS [Fabric Type] FROM tbl_Style INNER JOIN tbl_Info ON tbl_Style.FABRICID = tbl_Info.Infoid INNER JOIN tbl_Info AS tbl_Info_1 ON tbl_Info.Parent = tbl_Info_1.Infoid "When I write this query in SQL server 2005 is working, but when I copy and paste in to my ASP page come out this error:------------------------------------------------------------------Microsoft JET Database Engine error '80040e14' Syntax error (missing operator) in query expression 'tbl_Style.FABRICID = tbl_Info.Infoid INNER JOIN tbl_Info AS tbl_Info_1 ON tbl_Info.Parent = tbl_Info_1.Infoid'. ------------------------------------------------------------------The query is all in one line.I appreciate your help.Tom |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-29 : 02:21:13
|
| Why you are using JET provider to connect to SQL 2005? Why not use OLE-DB provider?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
tombino
Starting Member
26 Posts |
Posted - 2007-05-29 : 02:26:11
|
| because I export the SQL db in to Microsoft Access db. |
|
|
|
tombino
Starting Member
26 Posts |
Posted - 2007-05-29 : 19:19:31
|
| I tryed to write the query in Microsoft Access software and I have the same problem.Syntax error (missing operator) in query expression 'tbl_Style.FABRICID = tbl_Info.Infoid INNER JOIN tbl_Info AS tbl_Info_1 ON tbl_Info.Parent = tbl_Info_1.Infoid'. May I cant have 2 INNER JOIN in Access?Tom |
|
|
|
|
|
|
query problem