[rt-users] finding largest Attachments

[Stephen Turner]

I think you need to join with the Transactions table:

select length(A.Content), A.id, T.Ticket  from Attachments A, Transactions T
where A.TransactionId = T.id order by 1

Steve

At Monday 8/16/2004 01:53 PM, Dave Dennis wrote:
>Jesse,
>
>Thanks, that makes sense, except the output from Attachments.id
>is that same as the number of a ticket that one might search on
>through RT?
>
>
>Kind regards,
>
>+-------------------------
>+ Dave Dennis
>+ Seattle, WA
>+ dmd at speakeasy.org
>+ http://www.dmdennis.com
>+-------------------------