How can one select a row from an SQL table in n-times?
Using two tables in the same database
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
I meant; selecting a row in 10times and proceed executing same query to another row. thanks Shraddha