replacing related id with value when querying table

Hello, I've got two tables:

offices
└  id
└ name

employees
└ id
└ office_id
└ name

offices
└  id
└ name

employees
└ id
└ office_id
└ name

office_id in employees table is linked to offices.id.

When I query employees right now, I get something like

[
  {
    "user_id": "0dea707d-2248-4a2e-b8fd-b65578852ca9",
    "office_id": 1,
    "name": "Karen"
  }
]

[
  {
    "user_id": "0dea707d-2248-4a2e-b8fd-b65578852ca9",
    "office_id": 1,
    "name": "Karen"
  }
]

QUESTION:
is it possible to replace that office_id with office name so I get something like this when I query select * from employees

[
  {
    "user_id": "0dea707d-2248-4a2e-b8fd-b65578852ca9",
    "office": "Billing Department",
    "name": "Karen"
  }
]

[
  {
    "user_id": "0dea707d-2248-4a2e-b8fd-b65578852ca9",
    "office": "Billing Department",
    "name": "Karen"
  }
]

Supabase•4y ago•

9 replies

Hello, I've got two tables:

offices
└  id
└ name

employees
└ id
└ office_id
└ name

offices
└  id
└ name

employees
└ id
└ office_id
└ name

office_id in employees table is linked to offices.id.

When I query employees right now, I get something like

[
  {
    "user_id": "0dea707d-2248-4a2e-b8fd-b65578852ca9",
    "office_id": 1,
    "name": "Karen"
  }
]

[
  {
    "user_id": "0dea707d-2248-4a2e-b8fd-b65578852ca9",
    "office_id": 1,
    "name": "Karen"
  }
]

QUESTION:
is it possible to replace that office_id with office name so I get something like this when I query select * from employees

[
  {
    "user_id": "0dea707d-2248-4a2e-b8fd-b65578852ca9",
    "office": "Billing Department",
    "name": "Karen"
  }
]

[
  {
    "user_id": "0dea707d-2248-4a2e-b8fd-b65578852ca9",
    "office": "Billing Department",
    "name": "Karen"
  }
]