Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Bermuda
    Posts
    40

    Question Unanswered: 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

    robbied111
    Sunny Times...

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Is there a reason to have this CROSS-TAB-LOOK-ALIKE structure for #2?

  3. #3
    Join Date
    Jan 2004
    Location
    Bermuda
    Posts
    40
    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
    Sunny Times...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •