Been trying to figure out how to execute the following query using LLBLGen, and it seems like I've hit a mental brick wall...

SELECT DISTINCT [manufactureCode] FROM [Article] INNER JOIN [Vehicle] ON [Article].[V_ID] = [Vehicle].[Id] WHERE [Article].[P_ID] = @p1 AND [Vehicle].[M_ID] = @p2

Any ideas?

This should work:

DataAccessAdapter adapter = new DataAccessAdapter();
ResultsetFields fields = new ResultsetFields(1);
fields.DefineField(ArticleFields.ManufactureCode, 0);
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.Add(ArticleEntity.Relations.VehicleEntityUsingVId, JoinHint.Inner);

DataTable dynamicList = new DataTable();
adapter.FetchTypedList(fields, dynamicList, bucket, 0, null, false, null);

I'm assuming a few things here: -You are using LLBLGen 2.5 -You are using Adapter -The ManufactureCode field belongs to the Article Table -And of course, the naming of the mapped tables and fields in your project.

Your assumptions are correct, however.. I don't see the DISTINCT part anywhere?

The FetchTypedList method accepts a boolean parameter (allowDuplicates), you should set it to false as the example shown before.

Ahh, thank you, missed that.

Problem solved =)