[Rt-devel] Re: r3602 - in rt/branches/QUEBEC-EXPERIMENTAL: . lib/RT

[Ruslan Zakirov]

Ah, I thought there is LEFT joins already.


On 8/18/05, Alex Vandiver <alexmv at bestpractical.com> wrote:
> On Thu, 2005-08-18 at 17:25 +0600, Ruslan Zakirov wrote:
> > I don't see reason why you need LEFT JOIN for sorting. Could you show
> > us why we can't use prev. solution.
> 
> Otherwise the JOINs required to give us a requestors column to sort on
> leave out tickets that have no requestor; the LEFT JOINs give us nulls
> in the requestor columns, instead of the JOINS which would eliminate the
> row entirely.  The patch hence fixes a problem where sorting by
> requestor limited the tickets to those which had a requestor.
>  - Alex
> 


-- 
Best regards, Ruslan.