Print Page | Close Window

Help with SQL queries

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=28609
Printed Date: 28 March 2026 at 9:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Help with SQL queries
Posted By: alshamsi
Subject: Help with SQL queries
Date 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




Replies:
Posted By: dpyers
Date 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.


Posted By: alshamsi
Date 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.


Posted By: 123Simples
Date Posted: 25 May 2010 at 6:54pm
Good luck with your exam tomorrow Thumbs Up

-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net