Hi, This is driving me nuts, please tell me is this a bug or a problem wiht my query:
jappz_guestbook(owner_cno, sent_datetime, is_secret, accepted) jappz_member_profile(cno, pic_name) jappz_guestbook's owner_cno and jappz_member_profile's cno are the same what i need to do is select * from jappz_guestbook where owner_cno=x and only select pic_name from jappz_member_profile where cno=jappz_guestbook.cno This is my query: SELECT from_cno,from_usernam,sent_datetime,is_secret,accepted,jappz_member_profile. pic1 FROM jappz_guestbook INNER JOIN jappz_member_profile ON jappz_guestbook.owner_cno = jappz_member_profile.cno WHERE jappz_guestbook.owner_cno = jappz_member_profile.cno order by from_cno DESC limit 0,30 I am getting 4 results: from_cno from_usernam sent_datetime is_secret accepted pic1 1 r 2005-05-01 00:03:14 0 0 s.jpg 1 r 2005-05-01 00:04:09 1 0 s.jpg 3 ryana3 2005-05-01 01:15:57 0 0 s.jpg 3 ryana3 2005-05-01 01:16:06 1 0 s.jpg which is wrong because "pic1" for "from_cno" should be "r.jpg" but its somehow "cacheing" the above. Please advise. Thanks, Ryan A -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.0 - Release Date: 4/29/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]