Hello,

I'm working on extracting some data from a legacy system and there's some data presentation that I have to do.
I've created a mapping file on this table and I need to join another table on a key column (1-on-n). However, there are criteria that makes the joined table 1-1 which is actually what I need:

Say, Person has personId and there's a Pet with a personId and a petType column. This is the select that I want:
select ... from person left join pet pet on (person.personId = pet.personId and petType = 'dunno').

I did a <join element with the key column, now all I need is the additional contraint that the petType is always 'dunno'. I don't see a place holder for this, any way to solve this?

thanks,
lino