> It is not possible with that query. It is the essence of the query. I don't think grid processes left joins.
You might try smartgrid. It knows about left joins and gives you a link to the foreign table, but it doesn't display any information from specific rows in that table. Left joins are a pain however you handle them because a relational database gives you one row for every join. To use the dogs/owners example from the book, if Ivan owns six dogs and you connect Ivan to his dogs with a left join, the database gives you six rows of identical Ivan data with each row having unique data for one of the dogs. It is possible to process this output, but it takes a LOT of time to get it right from an appearance standpoint. I don't know how the nosql databases handle this, but I'm going to look into it. On Dec 14, 1:32 am, Johann Spies <johann.sp...@gmail.com> wrote: > On 13 December 2011 16:05, Cliff <cjk...@gmail.com> wrote: > > > Johann, > > > Does grid work if you comment out that left join? > > It is not possible with that query. It is the essence of the query. > > I do not have a problem with the grid using more general queries. > > Regards > > Johann > > -- > Because experiencing your loyal love is better than life itself, > my lips will praise you. (Psalm 63:3)
