Hi Michiel > I don't understand your problem, it is a bit tricky, but not difficult at all.
I copied and hacked an example, but obviously had to make changes - additional relation steps in particular, the resultant SQL has two insrel table names in the "FROM" portion of the select. It's not difficult, just complex code on a complex join, and I can't get it to generate the correct sql. > What excactly did you try to do? Did you read the tutorial and/or API-doc, did you looked at code > using SearchQuery? (it is used on several places in mmbase itself). A complex join - 2 minutes to write in sql, the whole day battling with SearchQuery :-) > Do you use bridge or core to implement the servlet? I'm using core to implement the servlet. I think I've found what I'm looking for - mmb.getConnection() returning a MultiConnection, I'll use that instead as I am simply doing selects against the data, no updates required. May I suggest a superclass of SearchQuery which generically performs the SearchQuery coding - by parseing a strict SQL query or from a list of fields, tables, relation type and condition statement? I'd be happy to write it if I had a working example of a complex SearchQuery join. Thanks Regards Emile
