select from multiple table?

Question

I have two table as below

persons:

ID , FNAME, LNAME ,GENDER

100 , A , B , M

images:

IMG_D,IMG_NM,ID_PERSONS

10 , 1.JPG  , 100
20 , 2.JPG  , 100
30 , 3.JPG  , 100

the question is: I WANT QUERY RETRIEVE ALL COLUMNS FROM table persons and only IMG_NM FROM table IMAGES WITHOUT REST OF COLUMNS IN TABLE IMAGES

I MAKE QUERY AS BELOW

SELECT ID,FNAME,LNAME,GENDER,IMG_NM FROM persons,images where ID= ID_PERSONS  GROUP BY ID

the result:

100 , A , B , M , 1.JPG

AND I WANT SHOW ALL IMAGES WITHOUT REPEATING REST OF COLUMNS LIKE THAT

ID , FNAME, LNAME ,GENDER,IMG_NM

100 , A , B , M ,1.JPG
                ,2.JPG
                ,3.JPG 

Answer 1

SELECT p.ID, p.FNAME, p.LNAME, p.GENDER, GROUP_CONCAT(i.IMG_NM) AS IMG_NM FROM persons p JOIN images i ON i.ID_PERSONS = p.id GROUP BY p.id;

Should handle what you're wanting nicely.