Thanks Gerard, I will try that at once.
-- Tobias ----- Original Message ----- > 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 -- Tobias Hieta Project Manager @ Purple Scout E-Mail: [email protected] Cell: +46 732 051 411 www: http://about.me/thieta
