Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ahmadsa
Starting Member
7 Posts |
 Posted - 2007-12-12 : 08:02:03
|
| Hotel(hotelno, hotelname ,city)Room(roomNo, hotelNo,type,price)i need the reltional algebra to list the price and type of rooms in the hilton hotelthanx |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-12 : 08:05:08
|
SELECT h.*, r.*FROM Hotel AS h INNER JOIN Room AS r ON r.HotelNo = h.HotelNoWHERE h.hotelname like '%hilton%'Say "hi" to your professor from me.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-12-12 : 08:06:17
|
| Join two tables with common key and apply where conditionMadhivananFailing to plan is Planning to fail |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-12-12 : 08:07:07
|
It is time to post Learn SQL links  MadhivananFailing to plan is Planning to fail |
|
|
|
ahmadsa
Starting Member
7 Posts |
Posted - 2007-12-12 : 08:09:00
|
| can you put that into a relational algebra operation with the "select" and where"thanx |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-12-12 : 09:37:34
|
| A better question is, can YOU?can you even TRY?[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQL or How to sell Used CarsFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
|
|
|
query help please (relational algebra)