Your table2 needs to have a foreign key id to table 1. I would have to guess on the limited information you provided that table 2 has a field named something like table1_id. Then you can just do this:
SELECT table1.id, table1,name, table2.rank, table2.position
FROM table1
LEFT JOIN table2 ON table1.id = table2.table1_id
You need to have a relationship between the tables or else you end up with some cross join that would likely be meaningless data.
Submit an article or tip