Getting Data That Is in One of Two Tables

Question:
I have a query that retrieves a field which is a foreign key in two tables. The tables are organization_name and person_name. Each instance of the foreign key is in one of the tables but not both.

How do I use the field to retrieve either the organization_name or the person_name, depending on which table matches the value of the particular instance of the foreign key? The fields I want to retrieve are called org_disp_name or pers_disp_name. I know I have to create another field_name and somehow fetch either org_disp_name or pers_disp_name into it, but nothing I’ve tried has worked.

Answer:
I’m a little puzzled by organization_name and person_name being table names; they sound like attributes to me. I’m also not sure if there is some ambiguity over which name got used or not.

The problem goes away if one table is structured like this:

FKColumnName, FKTableName, FKValue

This lets you map back to the table contributing the foreign key, know the column name to use, and the value to compare. I am assuming that the FKValue will yield the text representation you desire, one or the other of organization_name or person_name.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

microsoft careers

Top Careers at Microsoft

Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS