Jump to content


Help!! Trouble using sub-queries!!

  • This topic is locked This topic is locked
1 reply to this topic

#1 noisyassassin

  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 14 March 2006 - 08:04 PM

Hi guys hope you can help me with my queries!

What i need to do is the following queries for a vets database, 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!!


Below is the data that creates the tables if it helps:

create table owner
ownerID number(2),
surname varchar2(10),
forename varchar2(10),
address varchar2(20),
dateofbirth date,
primary key (ownerID)

create table vet
vetID number(3),
name varchar2(10),
primary key (vetID)

create table pettype
pettypeID number(2),
pettypename varchar2(10),
legcount number(2),
primary key (pettypeID)

create table pet
petID number(2),
ownerID number(2),
pettypeID number(2),
petname varchar2(10),
dateofbirth date,
primary key (petID),
foreign key (ownerID) references owner(ownerID),
foreign key (pettypeID) references pettype(pettypeID)

create table food
foodID number(2),
food varchar2(20),
primary key (foodID)

create table diet
pettypeID number(2),
foodID number(2),
primary key (pettypeID,foodID),
foreign key (pettypeID) references pettype(pettypeID),
foreign key (foodID) references food(foodID)

create table visit
visitID number(5),
petID number(2),
vetID number(3),
visitdate date,
treatment varchar2(20),
cost number(4,2),
primary key (visitID),
foreign key (petID) references pet(petID),
foreign key (vetID) references vet(vetID)

#2 obsidian

  • Staff Alumni
  • Advanced Member
  • 3,202 posts
  • LocationSeattle, WA

Posted 14 March 2006 - 08:08 PM

please avoid double posting. closing this topic.
You can't win, you can't lose, you can't break even... you can't even get out of the game.

while (count($life->getQuestions()) > 0)
{   $life->study(); } ?>
  LINKS: PHP: Manual MySQL: Manual PostgreSQL: Manual (X)HTML: Validate It! CSS: A List Apart | IE bug fixes | Zen Garden | Validate It! JavaScript: Reference Cards RegEx: Everything RegEx

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users