At 06:26 PM 25/06/2009, you wrote:

>If I understand correctly we're using form a), and it's still causing
>problems.

Form a) was not in either of your examples.

For form b) I made a typo when I copy/pasted, as well.  It should be

b) using aliases only:

select o.id, m.id from marker m, object o 
where m.id = o.id

>The Firebird database is not the one "complaining" but the "provider"
>itself.

Are you saying that you get the message like [an item with the same key has 
already been added] when you perform a SELECT?

>I mean, I don't have an issue due to syntax a) or b) or mixing them. The
>issue is because the Firebird provider can't handle (at least what
>showed up debugging the code) something like:
>
>select o.id, m.id
>
>since they both use the name "ID" as column name.

The provider could not work for anybody if that were true.  

>Is it clear now?

It seems there are some facts missing from your case.

Helen


------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to