db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Tilsted <til...@daimi.au.dk>
Subject Re: How do I control the join type of doSelectJoin?
Date Tue, 19 Feb 2008 00:52:13 GMT
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message