how to fetch all row from one table and select row from other table based on first table?

Question

i have a table one table message and other table is image . i want to fetch the data from image for the selected row from the message ( idea is that i want to display the images of sender that are stored in other table "IMAGE" and message are stored in other table "Message" Please help . this is not working

select  msg.Uid, msg.Fid, msg.Message, img.ImagePath, img.Uid 
FROM Message msg left OUTER JOIN Image img 
ON 
msg.Uid=img.Uid

Why is not working? Is it missing some images? If yes, you should try "RIGHT OUTER JOIN". — Thiago Lewin, Jun 07 '13 at 16:48

score 0 · Answer 1 · answered Jun 07 '13 at 20:50

We would need to know more about the tables, but just by looking at the column names it seems you are using the wrong Uid's. If you have a one-to-many (since you are saying "images from sender") relation from Message to Image, and each table has their own Uid, then on the Image table you should have a foreign key pointing to the Uid from Message, and the query would look something like this:

SELECT  msg.Uid, msg.Fid, msg.Message, img.ImagePath, img.Uid 
FROM    Message msg 
        LEFT JOIN Image img ON msg.Uid = img.MessageUid

how to fetch all row from one table and select row from other table based on first table?

1 Answers1