Regarding 6 tables - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Regarding 6 tables

Author

Topic

Kotti
Posting Yak Master

129 Posts

Posted - 2008-07-22 : 11:00:26

These are 6 tables Tbl_LkAskandAnswer ,Tbl_AskAndAnswer, UserMgmt , ProfileDetails ,Tbl_AnswerComments, Tbl_AskAndAnswerRating

Questionid from Tbl_LkAskandAnswer

Answer,Creationdatetime from Tbl_AskAndAnswer

Username from UserMgmt

photourl from ProfileDetails

comments ,Creationdatetime from Tbl_AnswerComments

rating from Tbl_AskAndAnswerRating

userid is common in UserMgmt,Tbl_AskAndAnswerRating,Tbl_AnswerComments,ProfileDetails

questionid is common in Tbl_LkAskandAnswer ,Tbl_AskAndAnswer

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-07-22 : 11:03:25

in the same class or actually the same person....?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=106774

Em

Kotti
Posting Yak Master

129 Posts

Posted - 2008-07-22 : 11:08:39

he is my friend

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-07-22 : 11:14:30

so both of you have no idea what you're doing?
simply join them together on the correct key columns.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!

Kotti
Posting Yak Master

129 Posts

Posted - 2008-07-22 : 11:18:21

[quote]Originally posted by spirit1

so both of you have no idea what you're doing?
simply join them together on the correct key columns.

_______________________________________________
Get unique username from Rating Table and Answer Table compare with User Table

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-07-22 : 11:21:04

quote:
Originally posted by Kotti

[quote]Originally posted by spirit1

so both of you have no idea what you're doing?
simply join them together on the correct key columns.

_______________________________________________
Get unique username from Rating Table and Answer Table compare with User Table

huh?

your 'friend' apparently got the answer they wanted so you just need to add in a 6th table. the join is all there for you already

Em

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-22 : 11:38:10

quote:
Originally posted by elancaster

quote:
Originally posted by Kotti

[quote]Originally posted by spirit1

so both of you have no idea what you're doing?
simply join them together on the correct key columns.

_______________________________________________
Get unique username from Rating Table and Answer Table compare with User Table

huh?

your 'friend' apparently got the answer they wanted so you just need to add in a 6th table. the join is all there for you already

Em

you dont know to copy and modify from it? atleast make a try..

VGuyz
Posting Yak Master

121 Posts

Posted - 2008-07-24 : 11:01:17

use the "design query in editor" option in sql server 2005
and get the tables from your database and then click the columns which you want from that table.the copy the query below and use it.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources