Ok here is my situation:
I have a database with a few tables.
FundsTable
Ticker(PK) | FundName
FundScoresTable
Ticker(FK) | Score | Replacement
Right now the Replacement is a ticker, but has no relationship
I need to run a query that will show:
Ticker | FundName | Score | ReplacementTicker | ReplacementName | ReplacementScore
I tried to relate the ticker in FundsTable to Ticker AND Replacement, but query produced nothing. Anybody have any advice?