while creating multiple tables if we have to retrieve the data of other table how can be do it by using foreign key concept ?

Answer 1

use joins, which will be based on foreign keys..