The following is a message from a fellow programmer to a group of use that
are involved in table design:
"We are planning on creating 'account opening sources' lookup table to store
'account source' codes and corresponding descriptions. Problem with storing

At one site,  I managed to verify that one of these two queries ran 10 to
100 times faster than the other:
select * from customers
  where country = 'US' and

Hi group,
I have an R:Base specific question, but didn't find an R:Base specific
newsgroup.  I do not know if there is any; if so, could you give me a
pointer?

Suppose there are N parties. Each party has R records, each of which
has D dimensions.
For example, N=3, parties are P1, P2, P3.
D=4, dimensions are named as (A,B,C,D).

I have been using MySQL on and off for a number of years but I am
stumped by this problem.
I am doing a select which requires a join to a second table using an
account key, I have a WHERE clause which ensures that I only get the

How do you return data from a function which can then be used in
a SELECT?
Here's a simplified version of what I'm trying to do.  Basically, I'm
trying to select all employees which belong to group 10, *or* to any

I still use the DBU 1986-1990 to create datbases but changing the
fields names cause the memo fields to be lost and all windows DBF
viewers are trial version and not freeware. Even the free when I open
it popup the error : wrong memo format .

I'm writing some code to suport a contact database, where a contact
can be either a person or a group.  Groups can contain people directly
and can also contain other groups.
The (simplified) table structure looks like this:

I have designed two tables, one for the main information of
maintenance, and the other for additional information. The additional
table is used when one column in the main table has the value of 1
meaning we will send it to other company to repair it. So in the