Database table joins

How to join two tables with out relationship?

If you have table Person with columns age, name and table Address with columns country, city, zip
and you would like to show persons with random address you should create Api Service with method getPersonsWithRandomAddress and wind Person in this method, then find Address, then return a collection with person and Address