How can one select a row from an SQL table in n-times?

Question

Using two tables in the same database

Answer 1

You can join 2 tables to select rows with data from both tables
Eg : consider 2 tables student_name and student_addrsss:
student_name has the following columns
roll_no, first_name, last_name
student_address has the following columns
roll_no, street_name, city_name

When you run the following querry
select * from
student_name sn inner join student_address sa
sn.roll_no = sa.roll_no

You get columns from both tables:
roll_no, first_name, last_name, roll_no, street_name, city_name

Answer 2

I meant; selecting a row in 10times and proceed executing same query to another row.
thanks Shraddha