Thomas Fischer wrote:
btw: I have newer understood the reason to use field joins at all.
Can anyone
enlighten me on in which cases one would use a field join
instead of a inner join?


Hm, in most databases (e.g. mysql, oracle, postgresql) the thing you call "field join" is an inner join (just a different syntax) so you already got what you wanted.

The problem with field joins are that if you use more then one in a single
query you get duplicate rows in your result,

This is not true in general. Could you give an example where this happens ?
Not a valid one. I was wrong about the joins, it does work exactly like(Is a) inner join, so you were right. There is not really a problem.

Martin






---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to