Hi, I have a database having some tables and I want to run a query which shows a result from multiple tables.
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.