Re: A non-relational prob

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 19 Mar 2001 21:25:36 -0800
Message-ID: <3AB6E9D0.22096296@exesolutions.com>

> <snip>
> Now, the question: how would I desing an sql select statement, that,
> given the language and the country of a user, returns the correct text
> in a _single_ line for a text id?

Do you have a table of users with that user's default language and country?

If so a simple join or outer-join should turn the trick.

Daniel A. Morgan Received on Mon Mar 19 2001 - 23:25:36 CST

This message: [ Message body ]
Next message: Rene Nyffenegger: "DBA leaving sql*plus unattended: security risk?"
Previous message: Rene Nyffenegger: "A non-relational prob"
In reply to: Rene Nyffenegger: "A non-relational prob"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US