Web Wiz - Solar Powered Eco Web Hosting

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

Help with SQL queries

 Post Reply Post Reply
Author
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


Joined: 12 May 2003
Status: Offline
Points: 3938
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
123Simples 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 123Simples Quote  Post ReplyReply Direct Link To This Post Posted: 25 May 2010 at 6:54pm
Good luck with your exam tomorrow Thumbs Up
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.