I made two tables,
one is for saving member's information such as member_id,name,address,email..etc.
And the other is for saving messages from the members (fields are such as member_id,subject,date,message..etc).
How do I implement SELECT SQL command which will extract the name,address,email according to subject,message,date from the two tables?

Ex)

Table A Table B

member_id name email ... member_id subject message ...
001 bill bill@test.com 001 sky memo1
002 ted ted@ms.com 002 stereo memo2
003 john john@yahoo.com 002 mono memo3
004 merry merry@net.com 003 mouse memo4
. . . . . .
. . . . . .
. . . . . .


Sql result

sky memo1 bill bill@test.com
stereo memo2 ted ted@ms.com
mono memo3 ted ted@ms.com
mouse memo4 john john@yahoo.com
. . . .
. . . .