0

I have 3 tables in the same database, with couple of columns as common and rest non-matching columns as well. I need to show them together in such a fashion that the user should be able to distinguish between the source tables (Refer below diagrams). I want to know if I can achieve this in database itself, before passing its result on to my report UI or code behind?

I have tried achieving this using OUTER JOIN, FULL OUTER JOIN. See here

Also here

Chewpers
  • 2,430
  • 5
  • 23
  • 30
user3672731
  • 1
  • Assuming your code is in the image links; FYI, folks at work (like myself) may not be able to view these images. I'd recommend posting your code directly in the question so a wider range of people can assist you. – levelonehuman Apr 08 '16 at 18:43
  • Could you not do a inner join based on common columns between 3 tables? – shahkalpesh Apr 08 '16 at 18:45

0 Answers0