Hi David, Thanks for the link. I'll try and search harder next time. I thought the problem was with the where parts rather than the inner joins. I'm sure I picked up the joined up syntax from the developer docs although I can't find the exact location now. Perhaps you could add a note about this change to the docs too? Thanks, Dan  

Hello Mike, I am new to ES and I have diligently searched for a clue to help me with this task, without success.  Table ''Service'' contains its own PK  ''SreviceOrder'' and table ''Notes'' contains FK ''ServiceOrder'' - pointing to the obvious (it also has a PK - auto-gen --for uniqueness) . Table ''Notes'' contains from 0 to N ...

Hi there I have a problem that the following source code is producing invalid SQL when it runs against my Access database.  The InnerJoin is missing a bracket and so I get a syntax error in FROM clause back from Access. Code: Dim jobItemQ As New JobItemsQuery(''j'') Dim payItemQ As New PayItemsQuery(''p'') ...

 Code: public bool LoadCustomerWIthAddress(int customerID) { AddressQuery addBill = new AddressQuery(''aBill''); AddressQuery addShip = new AddressQuery(''aShip''); CustomerQuery c = new CustomerQuery(''cq''); c.Select(addBill.Address1.As(''BADDR1''), ...

Hi Everyone, this is my first time using entity spaces. I am using a query that joins two tables and loading it into a collection object. The problem l have is that l cannot access the columns/values from the other part of the join from the object. here is the code l have for doing that.... If e.RowIndex >= 0 And e.ColumnIndex = ...

Hi Mike, Thanks for clarifying this. I gotta think though that if you're planning to do joins as I was but do a single table query first, it's mighty inconvenient that this approach of doing a no-table join just doesn't work. If the SQL generated included SELECT * from [withStatement] as it does when one table is being joined to another, ...