SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Regarding 6 tables
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Kotti
Posting Yak Master

India
129 Posts

Posted - 07/22/2008 :  11:00:26  Show Profile  Reply with Quote
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

Posted - 07/22/2008 :  11:03:25  Show Profile  Reply with Quote
in the same class or actually the same person....?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=106774

Em
Go to Top of Page

Kotti
Posting Yak Master

India
129 Posts

Posted - 07/22/2008 :  11:08:39  Show Profile  Reply with Quote
he is my friend
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 07/22/2008 :  11:14:30  Show Profile  Visit spirit1's Homepage  Reply with Quote
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
Go to Top of Page

Kotti
Posting Yak Master

India
129 Posts

Posted - 07/22/2008 :  11:18:21  Show Profile  Reply with Quote
[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
Go to Top of Page

elancaster
A very urgent SQL Yakette

United Kingdom
1208 Posts

Posted - 07/22/2008 :  11:21:04  Show Profile  Reply with Quote
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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 07/22/2008 :  11:38:10  Show Profile  Reply with Quote
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..
Go to Top of Page

VGuyz
Posting Yak Master

121 Posts

Posted - 07/24/2008 :  11:01:17  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000