How to write sql query for generating result
know the query to join two table
but the result is coming out as follows
I would not suggest you that SQL queried data should be manipulated/filtered via query in this case.
What you got from query result is perfectly fine. You
should not try to make any further changes in query to get the desired result.
Here, the final result is something that should be done in the front end on UI side.
Take the entire result and then hide the duplicate in the UI. I already shared exampled with you earlier:
i want to populate grid view with data from more than two sql server tables[
^]
No point in reposting again. If you think or don't find it suitable, talk to your senior/teacher to get direction.