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
Thursday, February 16, 2012
Cross Join/? Query in a View Help
Labels:
ccy,
columns,
cross,
currenciesccy_nameccy_code2,
database,
etcactive-gt,
microsoft,
mysql,
oracle,
query,
ratesccy1ccy2ccy3,
server,
sql,
tables1,
view
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment