Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    2

    Unhappy Unanswered: Help!! Trouble using subqueries!!

    Hi guys hope you can help me with my queries for a vet's database!

    What i am trying to do is the following queries, using sub-queries to get the answers:

    Query 1
    Give the names of those people who own a Cat but not a Dog. Concatenating the forename and surname into one column with the heading Owner Name. This is the only column that should be output.

    Query 2
    Give the name of the pets that have visited the vets on the most occasions. Outputing only the pet names.

    Query 3
    Give the names of the two pets that have cost the most in vets bills. Outputing only the pet names.


    Thanks in advance!!

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    this looks more like homework.
    Why not supply what you have written thus far and we'll see where you are going wrong.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Jan 2003
    Location
    China
    Posts
    38
    Quote Originally Posted by The_Duck
    this looks more like homework.
    Why not supply what you have written thus far and we'll see where you are going wrong.
    It must be, cause I am sure I've seen it somewhere.

    We can help you with your homework, but where are the tables (or views)? :-)
    Last edited by 884813; 03-15-06 at 05:00. Reason: .
    Fan Yi

Posting Permissions

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