cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lscoffield
Level: Powered On

How do you join 3 tables

How do you join 3 tables? here is the simple SQL

 

    SELECT studentClassMap.StudentId, studentClassMap.ClassId, [user].*, class.*

        FROM StudentClassMap as studentClassMap

        LEFT JOIN Class as class on class.ClassId = studentClassMap.ClassId
        Left JOIN [User] as [user] on [user].UserId = studentClassMap.StudentId

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How do you join 3 tables

@lscoffield 

I assume you mean how to do this in PowerApps...

If so then consider the following formula (in this case putting into a collection):

 

ClearCollect(colStudentClassMap, 
     AddColumns(
          StudentClassMap,
          "Class", Filter(Class, ClassId=StudentClassMap[@ClassId]),
          "User", Filter(User, UserId=StudentId)
     )
)

I hope that is what you are looking for.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

1 REPLY 1
Super User
Super User

Re: How do you join 3 tables

@lscoffield 

I assume you mean how to do this in PowerApps...

If so then consider the following formula (in this case putting into a collection):

 

ClearCollect(colStudentClassMap, 
     AddColumns(
          StudentClassMap,
          "Class", Filter(Class, ClassId=StudentClassMap[@ClassId]),
          "User", Filter(User, UserId=StudentId)
     )
)

I hope that is what you are looking for.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,391)