how to show one row where there is 2 row with same id

Accepted answer

Try this one out:

string qry = "SELECT distinct T1.SRCode,T1.SRDate,T1.Status,T2.Quantity,T2.Price,T2.NetAmount,T3.ProductCode,T3.ProductName FROM Tbl_ReceiveStock T1 INNER JOIN Tbl_ReceiveStockProducts T2 ON T1.SRId = T2.SRId INNER JOIN Tbl_Product T3 ON T2.ProductId = T3.ProductId ";

Tapan Patel9y ago

If you don't care about the other column data then you can use Row_Number function over your stockID column and get the rows which have row_number as 1 or you can use group by and aggregation over possible columns you want.

If you do care about other columns and data from another tables ( means - if you want to show the data from both the rows ), then there is no way to display it in one line.

Amit Gupta9y ago

You can use group by clause to group the result set by one or more column Check below link for reference https://www.w3schools.com/sql/sql_groupby.asp