//Here is the TSQL im using for the notmal join... SELECT Fund.FundID, Fund.FundDisplayName, FundManager.FundManagerID, FundManager.FundManagerDisplayName FROM Fund INNER JOIN FundFundManager ON Fund.FundID = FundFundManager.FundFundManagerFundID INNER JOIN FundManager ON FundFundManager.FundFundManagerFundManagerID = FundManager.FundManagerID WHERE (Fund.FundID = 2) //and here is the table it returns... FundID FundDisplayName FundManagerID FundManagerDisplayName 2 Test Fund 3 djkhrejr 2 Test Fund 1 test fund manager 2 Test Fund 2 jhsdfjhmgjhg //However for this particular report I need the data to be in this layout... FundID FundDisplayName FundManagerID1 FundManagerDisplayName1 FundManagerID2 FundManagerDisplayName2 FundManagerID3 FundManagerDisplayName3 2 Test Fund 3 djkhrejr 1 test fund manager 2 jhsdfjhmgjhg
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Connect with Certified Experts to gain insight and support on specific technology challenges including:
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE