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 |
|
nobug
Starting Member
1 Post |
 Posted - 2007-07-06 : 13:27:36
|
| Im trying to use a double LEFT JOIN like this:SELECT Varde, kostnader.projekt_id, priskategori_id, personal_id, Priskategori.namn, biljettyp.namn AS prisknamn FROM kostnader LEFT JOIN Priskategori ON kostnader.priskategori_id = Priskategori.ID LEFT JOIN biljettyp ON kostnader.biljett_ID = biljettyp.id WHERE kostnader.projekt_id = " & CLng(Request.Querystring("ID")) &"But im getting this:Syntax error (missing operator) in query expression 'kostnader.priskategori_id = Priskategori.ID LEFT JOIN biljettyp ON kostnader.biljett_ID = biljettyp.id'.somebody see the problem? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-07-09 : 06:14:57
|
| leave out the WHERE bit for the moment....and prove the LEFT JOINS are working...they look good. I know this is ACCESS...but you may have more success over at dbforums.com since we mainly handle MS SQLServer. |
 |
|
|
|
|
|
Double LEFT JOIN