sqlce & "The column name cannot be resolved to a table"

[Guest]

I have a sqlce database that I am getting strange errors with, well I don’t
think it’s the database I think its sqlce.

My select statement is retrieving a number of columns (35) from a number of
different tables (8). The tables might are a mix of INNER and LEFT joins. My
application and Query Analyzer on the PPC both get "The column name cannot be
resolved to a table. Specify the table to which the column belongs". My
select statement specifies table names in the select, the from and all the
joins. If I just select the field that sqlce says if bad from its table then
it works.

I have tried allsorts to try and solve the problem. I’ve removed the table
names from the select, exactly the same error

Hope this makes sense and someone has an idea of why sqlce is throwing
errors that aren’t errors.

Chris.

 

[Darren Shaffer]

please move over to microsoft.public.sqlserver.ce and
post your schema and your query. be happy to help you there.