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 |
|
brian_richards
Starting Member
1 Post |
 Posted - 2009-11-17 : 09:36:12
|
| in a relational db i ave 3 tables: table1: flight / destination / numberofseatsbooked ab123 / london / 1 bc123 / london / 2 cd123 / paris / 1 de123 / madrid / 0 table2: flight / seats / passengerid? ab123 / a1 / null ab123 / a2 / 1 bc123 / a1 / 2 bc123 / a2 / 1 cd123 / a3 / 1 table3: passengerid / name 1 / john 2 / bill 3 / david can any one please do a transact-sql query that compares table1.dest, table1.flight, and table3.name with the total number of seat bookings that exist for any combination of these attributes, and return it in a CUBE. reply will be greatly appreciated |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
trans-sql query