Re: Performance problems

[Josh Holtzman]

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]