Re: mysql joins

---- Steven Macintyre <steven@steven.macintyre.name> wrote: > I have three tables, namely; > > User > - UID > - Firstname > - Surname > - Tel > - Cell > - Email > > Tracker > - UID > - Points > > Winners > - UID > - Datetime (0000-00-00 00:00:00) > > I need to get the following information from the above tables (in my logical sense) > > All users from user with sum(points) as points and datetime > datetime + 14 days > > In English, the all users must be selected, excluding the ones that have won in the last 14 > days and return all the information and the sum of points > > I suspect I would need to use joins here ... but have no clue how to do so ... I have read up a > bit and can work out inner joins from three tables, but not coping with this problem above > > Can someone help me out with this please? > > Many thanks > > Steven What PHP code have you written so far? I personally would do a query on one table then use the results to grab the information from the other table. Some use joins, but I haven't seen a ton of time loss between the multi-short calls versus a join..