Multiple columns from 1 query field

[top1hat19]

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?

[pbaldy]

With your query in design view, if you add the FundsTable twice, it should alias the second instance (like "FundsTable_1"). You would join the actual table to one of your fields and the aliased version to the other.

[top1hat19]

Worked Perfectly! Thanks!

[pbaldy]

Happy to help!