Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    124

    Unanswered: help creating a formula

    I'm trying to create a formula where I can obtain an account name from an ID in another table.

    It is the equivalent of an innner join in SQL.

    SELECT account.name
    FROM account a
    INNER JOIN service_obligation o
    ON a.ID = o.ID

    How can I do this in Crystal? I have the ids from both tables and need to just get the name and number for the account.

    Thanks for any help.

  2. #2
    Join Date
    Dec 2004
    Location
    Connecticut
    Posts
    85
    The simplest way is to add the second table to the report. As you're doing that, you tell Crystal what type of join to use.

    Depending on the version of Crystal there may be a theoretical limit to the number of tables you can have in one report, but I've never hit it in 12 years.

Posting Permissions

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