SQL Query return data for 5 columns linked to the same Lookup Table

Question

SQL Query return data for 5 columns linked to the same Lookup Table

BigH61 581

I have a Main table that is joined to a second Table via the Main tables primaryKey. Within the second table there are multiple columns but 5 of these columns all reference the same lookup table. I have an SQL Query that returns all the relevant records from the Main table and the Second table with the exception of the 5 columns linked to one Lookup table. How can i return this data also. Thank you for your assistance.

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-04-07T20:58:17.4133333+00:00

Well, you add these columns as well. Or what is the problem? That is not clear to me. Generally, for this type of problem, it is a good idea to include CREATE TABLE statements for your tables together with INSERT statements with sample data and the desired result given the sample. This helps to clarify what you are looking for, and it makes it easy to copy and paste into a query window to develop a tested solution.

Accepted answer

0 additional answers

Your answer

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-04-07T20:58:17.4133333+00:00

Well, you add these columns as well. Or what is the problem? That is not clear to me. Generally, for this type of problem, it is a good idea to include CREATE TABLE statements for your tables together with INSERT statements with sample data and the desired result given the sample. This helps to clarify what you are looking for, and it makes it easy to copy and paste into a query window to develop a tested solution.

Answer 1

LiHongMSFT-4306 31,566

Hi @BigH61 Not sure what you actually want, but If I understood right, you need to use Join twice. Try something like this:

SELECT M.<column list>,S.<column list>,L.<column list>
FROM MainTable M JOIN SecondTable S ON M.primaryKey=S.ForeignKey
                 JOIN LookUpTable L ON M.primaryKey=L.ForeignKey

Best regards,

Cosmog Hong

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

BigH61 581 Reputation points

2023-04-10T14:01:27.2233333+00:00

Excellent. Thank you.

Share via

SQL Query return data for 5 columns linked to the same Lookup Table

0 additional answers

Your answer