| Author |
 Topic  |
|
|
Kotti
Posting Yak Master
India
129 Posts |
 Posted - 07/22/2008 : 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
United Kingdom
1208 Posts |
|
|
Kotti
Posting Yak Master
India
129 Posts |
Posted - 07/22/2008 : 11:08:39
|
| he is my friend |
 |
|
|
spirit1
Cybernetic Yak Master
Slovenia
11741 Posts |
Posted - 07/22/2008 : 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! |
Edited by - spirit1 on 07/22/2008 11:15:06 |
|
|
|
Kotti
Posting Yak Master
India
129 Posts |
Posted - 07/22/2008 : 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
United Kingdom
1208 Posts |
Posted - 07/22/2008 : 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
India
47023 Posts |
Posted - 07/22/2008 : 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 - 07/24/2008 : 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.
|
|
|
| |
Topic |
|
Regarding 6 tables
