Minesh Shah
asked on
How to query from multiple table
Hi, I have a database having some tables and I want to run a query which shows a result from multiple tables.
Tables Details:
Table 1. Groups (Columns: ID, Title)
Table 2. GroupMembership (Columns: GroupId, MemberId)
Table 3. UserInfo (Columns: tp_ID, tp_Title)
Group’s ID and GroupMembership’s GroupId having same entries so these two tables will interact on these columns and GroupMembership’s MemberId and UserInfo’s tp_ID having same entries so these two tables will interact on these columns.
Please find the table structure in attach file.
Now a query gives result:
Title from Group and tp_Title from UserInfo table.
Kindly guide.
Tables.docx
Tables Details:
Table 1. Groups (Columns: ID, Title)
Table 2. GroupMembership (Columns: GroupId, MemberId)
Table 3. UserInfo (Columns: tp_ID, tp_Title)
Group’s ID and GroupMembership’s GroupId having same entries so these two tables will interact on these columns and GroupMembership’s MemberId and UserInfo’s tp_ID having same entries so these two tables will interact on these columns.
Please find the table structure in attach file.
Now a query gives result:
Title from Group and tp_Title from UserInfo table.
Kindly guide.
Tables.docx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER