How to correctly filter SQL Table that involves other tables. Inner join?

(0) Share

Report

Posted on by Luffyloo

So basically, I have 3 tables that have to do with the Languages.

LanguageTable

-LanguageID

-LanguageName

PersonTable

-PersonID

-Info.......

Language_Person_Table

-PersonID

-LanguageID

So i have these 3 tables, with the Language_Person_Table used to link a person to a language. So if for example a person knows say english and spanish, then in the Language_Person_Table their would be 2 records with that PersonID attached to it.

The issue I am having is I cannot figure out how to use the LanguageIDs associated with a PersonID from this Language_Person_Table to then search for what the name of the Language is in the LanguageTable. I know I could just add the LanguageName to the linking table but I feel like that is most likely bad practice because it is redundant. Any help would be greatly appreciated. Cheers!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Luffyloo ,

Could you please share the detailed application scenario of your requirement/issue?

For example.
There is a gallery bound to Language_Person_Table, two labels in the gallery shows the LanguageID and PersonID. If you want to display the corresponding LanguageName, try to add another label in gallery, and set the Text property as below.

LookUp(LanguageTable, LanguageID=ThisItem.LanguageID).LanguageName

This code will return the LanguageName from LanguageTable based on the LanguageID.
Hope this helps. If not, please share more information about the application scenario.
Sik

Was this reply helpful? Yes No