[rt-users] advanced query

[Matt Zagrabelny]

Greetings,

Is it possible to perform an SQL join to another table when creating an
(advanced) query?

I am not looking at adding additional "search criteria", but rather
display more information.

I would like to get the "Real Name" of a requestor in the result set of
my query.

Any thoughts?

Thanks,

-- 
Matt Zagrabelny - mzagrabe at d.umn.edu - (218) 726 8844
University of Minnesota Duluth
Information Technology Systems & Services
PGP key 1024D/84E22DA2 2005-11-07
Fingerprint: 78F9 18B3 EF58 56F5 FC85  C5CA 53E7 887F 84E2 2DA2

He is not a fool who gives up what he cannot keep to gain what he cannot
lose.
-Jim Elliot
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090105/0c5f5369/attachment.sig>