I am attempting to join two lists, the idea is that I want to have two different sets of permissions for different parts of a list. I know column based security is not available so I figured by having two separate lists with a single view would allow different people to view/edit different data.
My problem is when trying to perform the joined data source via sharepoint designer 2013 most tutorials explain that after selecting two lists I can pick a shared column to use for the joining. This option however does not appear to me, the lists simply "join" and when the joined data source is displayed, it displays only one of the list's data while the columns from the other list are empty.