the simple answer is and b.name='name3' ?Bon
ChanceMartin______________________________________________Disclaimer and
confidentiality noteEverything in this e-mail and any attachments relates to
the official business of Sender. This transmission is of a confidential nature
and Sender does not endorse distribution to any party other than intended
recipient. Sender does not necessarily endorse content contained within this
transmission.> Date: Sun, 30 Dec 2007 13:54:32 +0100> From: [EMAIL PROTECTED]>
To: mysql@lists.mysql.com> Subject: Re: Help with query, (question simplified
as last mail was very complicated to understand :))> > Richard a écrit :> >
Sorry about my last email which was long and not clear.> > This is what I want
to do> >> > Join two tables on "code table1" = "code table3" where messageid =
for > > example 28> >> > table 1 contains :> >> > message from messageid> >
------------------------------------------> > message1 | code1 | 28> > message2
| code1 | 28> > message3 | code1 | 28> > message4 | code1 | 29> >> >> > table 2
contains> >> > name | code | num> > --------------------------------------> >
name1 | code2 | 1> > name2 | code1 | 2> > name3 | code1 | 3> >> > If I do :> >
SELECT a.message,,b.name FROM table1 a JOIN table2 b ON a.code=b.code > > WHERE
a.id='28'> >> > I get :> > message | name> > ---------------------------> >
message1 | name2> > message2 | name2> > message3 | name2> > message1 | name3> >
message2 | name3> > message3 | name3> >> >> > But all I want to get is :> >> >
message | name> > ---------------------------> > message1 | name3> > message2 |
name3> > message3 | name3> >> > If I do :> > SELECT * FROM table2 WHERE code =
'code1' ORDER BY num DESC LIMIT 1> >> > I get :> >> > name | code | num> >
--------------------------------------> > name3 | code1 | 3> >> > I now need to
somehow combine the two to get :> >> > message | name> >
---------------------------> > message1 | name3> > message2 | name3> > message3
| name3> >> > Of course I have simplified everything down to the minimum :)> >>
> Thanks in advance,> >> > Richard> >> >> As I have had no answer I presume
that what I want to do is not possible > or my question is not well explained.
Anyhow I've rethought the system > so I do not need to keep members information
and now instead of adding a > new entry I will now just change the existing
one. I won't keep old > members information in the database but I'll still have
the database > daily backups if I need the old information.> > -- > MySQL
General Mailing List> For list archives: http://lists.mysql.com/mysql> To
unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]>
_________________________________________________________________
The best games are on Xbox 360. Click here for a special offer on an Xbox 360
Console.
http://www.xbox.com/en-US/hardware/wheretobuy/