This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 0%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
I have multiple tables in which after joining I want the result as per below table. We have 5 fields: A,B,C,D,E Logic: There is 1:N relation means for every B we have some multiple E.
I want a output as per below
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Hi @MV_57 , welcome to Microsoft Q&A forum.
As mentioned by @Sreeju Nair that using a inner join clause will help you in writing the query to get the result.
However if you could provide the structure of tables (ddl for tables), we can help you writing the query that can get us the same result.
You can use join clause in SQL to get the desired results.
https://learn.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-ver15