List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:December 30 2007 3:29pm
Subject:RE: Help with query, (question simplified as last mail was very
complicated to understand :))
View as plain text  
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: mysql_list@stripped> To: mysql@stripped> 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/mysql?unsub=1 
_________________________________________________________________
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/
Thread
help with a query...Richard28 Dec
  • Help with query, (question simplified as last mail was very complicatedto understand :))Richard29 Dec
    • Re: Help with query, (question simplified as last mail was very complicatedto understand :))Richard30 Dec
      • RE: Help with query, (question simplified as last mail was verycomplicated to understand :))Martin Gainty30 Dec