Re: arrrggghhh!! Select statements..

Emily <Emily@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

THIS DID IT. Can you explain if it isn't too much trouble why it does this?
I just want to understand instead of just following blindly.

You said to select from two tables. Every row in one table will
be matched against every row in the other table for the condition that
you specify. No condition means every possibility.

Your condition has to be restrictive enough to eliminate the
combinations that do not apply. When do you want to see a
combination? That is your condition.

Commonly, your where condition will include each of the common
column types. Note that I did not write "column names". Two columns
might be of the same type, but have different names.

[snip]

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.
.

Relevant Pages

  • Re: Male vs Female viewpoints in SF
    ... But it's also true that some viewpoints about ... things are fairly common. ... Different people have different preferences when it comes to food. ...
    (rec.arts.sf.written)
  • Re: South African scammer BINs my auction!
    ... You might also want to change your preferences to "Immediate ... Payment Required" if these scams are common to ...
    (alt.marketing.online.ebay)
  • Re: Publish America Victim.
    ... They take a similar attitude toward your preferences, of course, which ... God loves the common man, and the common man loves UGK. ...
    (rec.arts.sf.written)
Loading