Cross Join/? Query in a View Help

Hey All...
Got a View question.
Have 2 tables:
#1 Currencies
|CCY_Name|CCY_Code|

#2 Rates
|CCY1|CCY2|CCY3|...etc|Active|
-> where the Columns CCY# = the Records in #1

How do I build a View to Select the ONE record in #2 where Active=Y, having the CCY_Name from #1 based on #2.CCY1 (Column NAME) = #1.CCY_Code (Record).

Thanks

robbied111Is there a reason to have this CROSS-TAB-LOOK-ALIKE structure for #2?|||To keep a single record in the table by a Date.

Its currently in an ASP page via 2 Arrays, but it would be more convenient to have it in a View.

Thanks