SELECT db1.name, db1.age, db1.email, db2.height, db2.weight, db2.shoesize FROM db1, dbi WHERE db1.name = db2.name AND other="test"