Yes. The technique of joining two or more tables together in a relationship is what makes a database "relational." As with any database, in designing for scalability, care must be taken to avoid excessive reliance on joins, which tend to be resource-intensive.