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-07-09 : 19:54:41
|
| What is the best way to compaire information in two differant tables when they don't share a linking coulmn?--For thouse with wings, fly to your dreams. |
|
|
MichaelP
Jedi Yak
2489 Posts |
|
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
Posted - 2002-07-09 : 20:30:27
|
| I am sorry I did no realize I posted this in the SQL foum. I clicked on the wrong link. I am trying to compaing information in two tables useing the if statment in ASP.--For thouse with wings, fly to your dreams. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-07-09 : 21:53:34
|
| It's much better and faster to do in SQL.What are you comparing?Michael<Yoda>Use the Search page you must. Find the answer you will. |
|
|
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
Posted - 2002-07-10 : 01:50:57
|
| I am trying to automate my RPG and there is the option to spar with your teammembers. Want I want to do is go out and look at the table "teams" and return the team information for that players team. Then compare the information from that table (which would be the Player Name) with the information in a table called "PlayerINFO" and see if they are at the same locaiton as the Player. SO if player "A" is at Earth and his team Captain (Player "B") is too and they both want to spar it will reconize it. I hope that is not too confusing.--For thouse with wings, fly to your dreams. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-07-10 : 06:02:48
|
| as usual......supplying table structures, sample input data and sample expected results should result in a faster + more complete answer.....descriptive requests like this one, require us to imagine your problem + solution.....if you make it easy for us....help will arrive faster. |
|
|
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
Posted - 2002-07-10 : 06:48:00
|
| Ok, well here it goes. 2tables. Table Teams has coulmns TeamName, Karma, Captain, Member1, Member 2 .. Member9, Waiting, CapSpar, Spar1, Spar2 ... Spar 3. Just like the coulmn name stats, TeamName is for the TeamName Cpatian is the Name of the Captain, Karma is if they are a good or bad team. Member 1 is the first member, Spar 1 is if the 1st member will spar with there team. Then there is table "PlayerINFO" which has columns PlayerID(Unique to each player), CharacterName, ICQnumber, Race, UID, Pass, Location, PageName, InFight. What I want to do is look and see if a person on the players team is willing to fight and then if they are at the same location and if they are write back to a web page with this code "<option value='spar(player's name to spar with)'>Spar with (Player's name to spar with)</option>And do it for each player on his/her team that is in the same location and willing to spar with there team.--For thouse with wings, fly to your dreams. |
|
|
|
|
|
|
|
|
Best way to compare two tables