It may interest you to see proof of the data in the SQL database - that which we have seen displayed in the WPF data grids previously.
I have added to that data shown in Robert's sample posting - we now have three flat Tables, and an extra column or two, as well as an extra row here and there.
I added just sufficient data to be able to test out two Left Outer Joins in the same query.
Once you get your head into this stuff it becomes really quite easy / doable. Honestly !
Regards,
Phil.
- XS_RobExampJoin_04.jpg (45.41 KiB) Viewed 156 times
- XS_RobExampJoin_05.jpg (61.57 KiB) Viewed 156 times
- XS_RobExampJoin_03.jpg (107.53 KiB) Viewed 156 times