replacing related id with value when querying table
Hello, I've got two tables:
office_id in employees table is linked to offices.id.
When I query employees right now, I get something like
QUESTION:
is it possible to replace that office_id with office name so I get something like this when I query select * from employees
office_id in employees table is linked to offices.id.
When I query employees right now, I get something like
QUESTION:
is it possible to replace that office_id with office name so I get something like this when I query select * from employees