query help

  • Thread starter Thread starter tucker
  • Start date Start date
T

tucker

Hi there im finding truth tables a little ahrd to understand, i
manged
to crack them,but now am having issues with query statements.

I ahve an exam at the end of the month and this has a chance of
comign
up so i want to know how to do it.


i was looking at a past paer and these questions come up which i cant
for the life of me work out. espically with the "WHERE" being used


can someone help me.. thanks in advance


Write down a query statement (as if following WHERE in an SQL
statement)


all female students who do not live within 10km of Blake University
or
less then 19 years old?


all students not called Jones or Smith or less then 1.75m tall?
 
Sorry, but I think you need to do a bit more studying, as on the face of it,
those look like fairly easy queries.

Unfortunately, without knowing what the table(s) involved look like, no one
is capable of supplying you with an answer.
 
Hi there im finding truth tables a little ahrd to understand, i
manged
to crack them,but now am having issues with query statements.

I ahve an exam at the end of the month and this has a chance of
comign
up so i want to know how to do it.


i was looking at a past paer and these questions come up which i cant
for the life of me work out. espically with the "WHERE" being used


can someone help me.. thanks in advance


Write down a query statement (as if following WHERE in an SQL
statement)


all female students who do not live within 10km of Blake University
or
less then 19 years old?


all students not called Jones or Smith or less then 1.75m tall?
Click to expand...

Ummm...

It really looks like you're asking us to do your homework. Giving you the
answer will help you answer the question, but if you don't understand Boolean
logic or truth tables or how the AND and OR operators work, you'll flunk your
exam anyway, so it won't do you any good.

Think of AND and OR as if they were arithmetic operators like + or -. Just as
2+2 = 4, so

(any True expression) AND (any True expression) = TRUE
(any True expression) AND (any False expression) = FALSE
(any False expression) AND (any False expression) = FALSE
(any True expression) OR (any True expression) = TRUE
(any True expression) OR (any False expression) = TRUE
(any False expression) OR (any False expression) = FALSE

Put your field criteria in place of the (any ... expression) and remember that
a WHERE clause retrieves a record if the result is TRUE.
 
Back
Top