First I will say I have spent almost a week on this problem which I thought was going to be done days ago. I have searched google, I have tried plugins, I have have tried custom mysql queries, I have tried every possible thing I can think of. If you can help here my appreciation is beyond grateful.
I have a multisite network with 2 blogs. It is very easy to use the switch to blog function to do a single query exclusively from the other blog and to output the results.
The Current Issue
However recently I got a request to do a query that pulls from both blogs simultaneously based on identical category names and outputs the posts from both blogs onto a single blog. Sounds simple enough right?
I can't seem to figure out why I can't I find any documentation any where online to do this simple task with code? I am not interested in using plugins as I have already tried a few and they either do not work for my needs, or are not functioning as advertised on my wordpress network. Unfortunately I cannot afford to invest any more time to trouble shoot plugins or compatibility with my multisite network and particular plugins because I have already lost a week, and I imagine something simple like this should be doable via code.
One of the selling points of multisite I was so happy about is I heard that it makes it easy to share content between blogs. This has to have a simple enough solution.
Can anyone help?! If so I will be forever grateful.