Results 1 to 7 of 7

Thread: Data Queries

  1. #1
    Join Date
    Sep 2011
    Posts
    11

    Unanswered: Data Queries

    My lecturer called us to create 4 useful queries for your database. What actually are queries?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > What actually are queries?

    SELECT statements
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2011
    Posts
    11

    Re:

    Not joining tables?

    So, if queries are SELECT. Then it might (Example) be

    SELECT lastname,state
    FROM customers
    WHERE state = 'FL';

    right?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >right?
    correct
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Sep 2011
    Posts
    11

    Re:

    ok. So how about joining table? are they related?

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >ok. So how about joining table? are they related?

    SELECT that join two or more tables are query; also.

    Some times desired data resides in a single table &
    at other times desired data resides in more than 1 table.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Sep 2011
    Posts
    11

    Re

    oo. ok thanks. get it. That's means joining table are optional

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •