Posted by Hugo Kornelis on 11/18/05 23:15

On 18 Nov 2005 01:50:35 -0800, Andy Kent wrote:

>There's not much to add except SELECT <list-of-cols>. It happens
>whether I select three or four columns or the whole twenty or so.

Hi Andy,

I typed "SELECT something" in Query Analyzer and added a copy of the
first (partial) query from your first post - the error I got was about
missing invalid object name (figures - I don't have your tables), so the
syntax check passed alright.

I then type "SELECT something", pasted the second (partial) query and
submitted the query - and I got the same error.

Conclusiion: none of these queries result in "sytax error (missing
operator)" on my database.

Did you use copy and paste to get the code in the message, or did you
copy it by hand? If the latter is the case, then please select the
query, hit copy and paste it in a new message - maybe that'll help me
catch the bugger.


>Used a WHERE clause to define the joins for now but I'm still curious
>why SQL Server generates code that it then throws out.

I'm curious too.

Some more questions:

- What tool do you use to generate the code? Access, DTS, Enterprise
Manager, other?
- Where are the tables that you get the data from (Access, SQL Server)?
- Where is the query executed (Access, SQL Server)?

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

[Back to original message]