How can I create a filter that would result in something like

Select view1.* from view1 inner join view2 on view1.Id = view2.Id

I need the inner join because I would like to filter on the columns from the view2

Version of the generator that we are using is 1.0.2004.2 Final (released 26.05.2005) and the code is generated using the Adapter scenario.

Did you try to map those views to Entities? So you can define relation between them.

And then build your RelationPredicateBucket and pass it to the FetchEntity()

I can't do that because I already have all the views mapped in the LLBLGen as Typed views and they are used as datasource for the grids throughout the application. That would cause too many changes in the application so I'm looking for a different solution.

You can add an EntityRelation object manually in code, see for details one of the generated Relation classes in the generated code.

To fetch the typedview data, you then use teh dynamic list syntaxis.

You da Man