Re: Join tables that has fields with same name

2003-09-10 Thread Jakob Braeuchi
hi istvan, this looks like a problem in your mapping. if ojb finds descriptors for the fields it prefixes them with a table alias (a.name). if no field is found the name from the criteria is used. hth jakob Viczián István wrote: Hi, I would like to join two table, and they are in 1:n relation,

Join tables that has fields with same name

2003-09-09 Thread Viczián István
Hi, I would like to join two table, and they are in 1:n relation, and they have a field with same name. If I add a criteria to this, I get an exception. This exception says, that the field is _ambiguous_. I've logged the SQL query with P6Spy, and it is true, the name of the field appears in the se