Query error

[werks]

Please help me on this error in query.

[CODE=mysql]
select `q`.`AccessionN o` AS `AccessionNo`,` q`.`CallNo` AS `CallNo`,`q`.`T itle` AS `Title`,`q`.`Au thors` AS `Authors`,conca t(`q`.`Publishe r`, ', ', `b`.`PlaceOfPub lisher`, ', c', `b`.`Copyright` ) AS `Publication`,` q`.`Remarks` AS `Remarks`,`b`.` ISBN` AS `ISBN`,concat(` b`.`Volume`, ', ', `b`.`Pages`) AS `Description`,

concat(`s`.`Sub ject1`, ', ', `s`.`Subject2`, ', ', `s`.`Subject3`, ', ', `s`.`Subject4`, ', ', `s`.`Subject5`, ', ', `s`.`Subject6`, ', ', `s`.`Subject7`, ', ', `s`.`Subject8`) AS `Subject`,`q`.` Copy` AS `Copy`,`q`.`Pub lisher` AS `Publisher` from

((`qrybooks` `q` join `tblbooks` `b` on((`q`.`Access ionNo` = `b`.`AccessionN o`))) join `tblsubject` `s` on((`b`.`TitleI D` = `s`.`SubjectID` ))) order by `q`.`AccessionN o`)
[/CODE]

It is somewhere in the bold part..
--
Kenneth
"Better Than Yesterday"

[werks]

This is the error

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5
(0 ms taken)

[ronverdonk]

All I can see from this melee is that you have 9 opening parentheses and 10 closing parentheses, i.e.

line 1: 2-2
line 3: 1-1
line 5: 6-7

Start there.

Ronald

[werks]

tnx.. fixed it

--
Kenneth
"Better Than Yesterday"