Web Wiz
Home
Home		 Hosting Services
Hosting Services		 Knowledgebase
Knowledgebase		 Community and Support Forums
Support Forums		 Customer Login
Customer Login

  New Posts New Posts RSS Feed - Help with SQL queries
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Windows Web Hosting 30 Day Free Trial

Windows Web Hosting 30 Day Free Trial

Windows Hosting 30 Day Free Trial, with no obligation, on all our Windows Web and Reseller Hosting Packages.

For more information see our Windows Hosting 30 Day Free Trial page.

Help with SQL queries
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
alshamsi View Drop Down
Newbie
Newbie
Avatar

Joined: 23 May 2010
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote alshamsi Quote  Post ReplyReply Direct Link To This Post Topic: Help with SQL queries
    Posted: 23 May 2010 at 5:17pm
Hi  can any one help me with the following sql queries:

Property (propertyRef, location, categoryId, type)

Viewing (propertyRef, clientNo, viewingDate)

Category (categoryId, categoryName)

PropertyType (type, description)

Client (clientNo, name, address)

 

TABLE: Property

 

propertyRef

location

categoryId

type

P001

1 Coventry Road

C11

DEG

P002

166 London Road

C12

DEG

P003

41 Great Avenue

C12

SDE

Back to Top
dpyers View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 May 2003
Status: Offline
Points: 3941 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 25 May 2010 at 8:29am
lol - looks like someones trying to get their homework done for them.

Lead me not into temptation... I know the short cut, follow me.
Back to Top
alshamsi View Drop Down
Newbie
Newbie
Avatar

Joined: 23 May 2010
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote alshamsi Quote  Post ReplyReply Direct Link To This Post Posted: 25 May 2010 at 5:38pm
it is not a homework, it is a previous exam questions,
i am practicing for the database exam, which is tomorrow (26/05/2010), and thought it would help to get the model answer for previous exams.
Thanks for the reply anyway.
Back to Top
MrTWS View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MrTWS Quote  Post ReplyReply Direct Link To This Post Posted: 25 May 2010 at 6:54pm
Good luck with your exam tomorrow Thumbs Up
Visit 123 Simples Web Design
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



Become a Fan on Facebook Follow us on Twitter Web Wiz on Google+ Community Forums Web Wiz Blogs Web Wiz News
Company Information | Contact Web Wiz | Terms & Conditions | Privacy Policy

Prices exclude VAT unless otherwise stated - $, € prices shown as a guideline only
Web Wiz Ltd, Unit 10E Dawkins Road Ind. Est, Poole, Dorset, UK, BH15 4JD
Copyright ©2001-2012 Web Wiz - All rights reserved