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 |
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
 Posted - 2002-04-29 : 01:09:06
|
| Does anyone know how I might do this? I think I need to do it though both t-SQL and ASP but am not sure. I have a Database (SQL server 2000) and three tables (Stats, Items, PublicINFO) and I want to write a script that goes out and looks at the stats table then at the PublicINFO table (to see what items that person has) and then goes out to the ITEMS table and adds the stats and the modifier of that item and then returns the sum on a web page. Example: Person has Strength as 50 and has an Item that increases strength by 5. I want the script to go look to see if they have that item and if they do to return to the web page 55. Thanks for the help. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-04-29 : 16:45:33
|
| I'm sure we could help you with your SQL statement to return this data, but it would be a lot of help if you would post your table definitions (preferably in the form of CREATE TABLE statements) and some sample data (preferably in the form of INSERT statements).Without that info, I can't even guess how Stats, Items, and PublicInfo are all related (and therefore could be joined). |
 |
|
|
|
|
|
How do I do this?