queries - simple, joint and multiple

[Lynnemcg1]

Hi

For a database I have been creating I have been asked to include 6 simple, 6
joint and 6 multiple queries.

I'm guessing a simple query is one which includes only one table but what are
the other two? I think maybe joint is more than one table joined together in
the query, and multiple involves using or and stuff.

I know how to use all these, I just don't know these definitions, and I'm not
even sure whether this is how they are globally known :¬S

Thanx for any help, Lynne

[Brendan Reynolds]

Re: queries - simple, joint and multiple

To the best of my knowledge, no, these are not standard definitions. I can
only suggest that you ask the person who gave you this assignment for
clarification.

--
Brendan Reynolds


"Lynnemcg1" <lynnemcg1@aol. com> wrote in message
news:2004022010 1229.25958.0000 0039@mb-m01.aol.com...[color=blue]
> Hi
>
> For a database I have been creating I have been asked to include 6 simple,[/color]
6[color=blue]
> joint and 6 multiple queries.
>
> I'm guessing a simple query is one which includes only one table but what[/color]
are[color=blue]
> the other two? I think maybe joint is more than one table joined together[/color]
in[color=blue]
> the query, and multiple involves using or and stuff.
>
> I know how to use all these, I just don't know these definitions, and I'm[/color]
not[color=blue]
> even sure whether this is how they are globally known :¬S
>
> Thanx for any help, Lynne[/color]

[Bas Cost Budde]

Re: queries - simple, joint and multiple

Lynnemcg1 wrote:
[color=blue]
> Hi
>
> For a database I have been creating I have been asked to include 6 simple, 6
> joint and 6 multiple queries.
>
> I'm guessing a simple query is one which includes only one table but what are
> the other two? I think maybe joint is more than one table joined together in
> the query, and multiple involves using or and stuff.
>
> I know how to use all these, I just don't know these definitions, and I'm not
> even sure whether this is how they are globally known :¬S
>
> Thanx for any help, Lynne[/color]

It looks like an abstract request to me, one that a manager could make. :-)

A simple query could very well mean one without a WHERE clause. Or one
without ORDER BY, or not having GROUP BY.

Joint? That makes me think of something outside computers.

Multiple? How are you supposed to create one thing that is multiple at
the same time? And then 6 times...

I agree with Brendan: go back to the asker. This is unclear, and maybe
even unfair.

--
Bas Cost Budde

http://www.heuveltop.org/BasCB

but the domain is nl