Tobias
Something similar to
FROM Tickets AS Ticket
JOIN Groups AS ReqGroup ON
ReqGroup.instance = Ticket.id
JOIN GroupMembers AS ReqGroupMember ON
ReqGroupMember.GroupId = ReqGroup.id
JOIN Users AS Requestor ON
ReqGroupMember.MemberId = Requestor.id
should do the trick
Gerard
On 2011-02-09 11:19, Tobias Hieta wrote:
Hello,
First of all I would like to say: I know this is not the best way to do it, I
know the underlying database will probably change and my non-warranty is even
more void. BUT, I would like to select requestors and owner etc from a ticket
directly on the database (I am using MySQL), I have tried to figure out how to
get the requestor from the tables by looking at the schema and the code, but it
eludes me. Can someone point me in the right direction on how to make a direct
select statement to get this information?
Thanks,
Tobias
--
Gerard FENELON Corporate Support
Emulation& Verification Engineering
2 bis, voie La Cardon
phone: +33 1 6453 2734 Parc Gutenberg
fax: +33 1 6453 2740 91120 Palaiseau
http://www.eve-team.com FRANCE
