Re: Sql Mobile Left Outer Join

Tech-Archive recommends: Fix windows errors by optimizing your registry

you have some other problem going on - I can run the
query below against the Northwind SQLMobile database
without issue.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com


"Tony Hudson" <TonyHudson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:00BE3DD8-9264-43FA-B19B-CCBD2E59A12E@xxxxxxxxxxxxxxxx
>I can not get this to work on one of our sql server mobile databases.
> Verification of the syntax fails stating that this command is not
> supported
> by the vendor.
>
> Is left outer joins availble in SQLMobile or am I going to have to code
> around this problem?
>
> --
> Tony Hudson
>
>
> "Darren Shaffer" wrote:
>
>> yes, it works - your syntax is just a little off. run it this way:
>>
>> SELECT Customers.*, Orders.*
>>
>> FROM Customers LEFT OUTER JOIN
>>
>> Orders ON Customers.[Customer ID] =
>>
>> Orders.[Customer ID]
>>
>>
>> --
>> Darren Shaffer
>> ..NET Compact Framework MVP
>> Principal Architect
>> Connected Innovation
>> www.connectedinnovation.com
>>
>>
>> "Twingo" <martin@xxxxxxxxx> wrote in message
>> news:1127991543.364464.288440@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> > Hi..
>> >
>> > I'm trying out sql server mobile and VS 2005. When I try to make a
>> > simple outer join query on the northwind database I get this error:
>> >
>> > "There was an error parsing the query. [ Token line number = 1, Token
>> > line offset = 555, Token in error = { ]"
>> >
>> >
>> > This is the query (generated by VS2005):
>> >
>> > SELECT Customers.*, Orders.*
>> > FROM { oj Customers LEFT OUTER JOIN
>> > Orders ON Customers.[Customer ID] =
>> > Orders.[Customer ID] }
>> >
>> >
>> > I'm almost sure this was working on CE 2.0.
>> > I also have other querys from my CE 2.0 project with subquerys that
>> > doesn't work in 3.0.
>> >
>> > Thanks
>> > Martin
>> >
>>
>>
>>


.

Relevant Pages