[prev in list] [next in list] [prev in thread] [next in thread] 

List:       turbine-torque-user
Subject:    Re: Performance problems
From:       Josh Holtzman <josh () joshholtzman ! com>
Date:       2003-11-27 17:28:44
[Download RAW message or body]


Thanks Dave.  Looks like I need to freshen up on my options for doing 
joins...  nulling the eliminated data sounds to me like just the ticket.

Cheers,
Josh

Dave Newton wrote:

>On Thu, 2003-11-27 at 03:21, Josh Holtzman wrote:
>  
>
>>Thanks Andras.  I thought about doing joins, but I run into this 
>>problem:  Not all accounts have an assignment.  I still want to show the 
>>accounts with no assignments, and the join keeps any account without an 
>>assignment out of the results.
>>    
>>
>
>Try flipping your join around or using a different join--you can tweak
>it so that the joined table's columns are NULL if it's not in the join.
>
>Uh... Tryptophan, playing with my neurons.
>
>In any case, you can have joins that eliminate data, or joins that NULL
>data that would otherwise be eliminated.
>
>Dave
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org
>
>  
>


[prev in list] [next in list] [prev in thread] [next in thread]