var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Cross Join/? Query in a View Help
Got a View question.
Have 2 tables:
-> 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).
Is 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.