|
-
Nov 27th, 2007, 12:57 AM
#1
Thread Starter
Just Married
[RESOLVED] I want to change the view of the query.
Hi all
Please look the table query.
SELECT [Post_ID]
,[Post_Category_ID]
,[Post_Title]
,[Post_Description]
,[Is_Email_Notification]
,[Attachment_URL]
,[User_ID]
,[Is_Delete]
,[Is_Move]
,[Is_Close]
,[Total_Views]
FROM [Cfamla].[dbo].[Post_Detail]
SELECT [Post_Reply_ID]
,[Last_Modification_Date]
,[Post_ID]
,[Reply_Title]
,[Reply_Description]
,[Is_Email_Notification]
,[Attachment_URL]
,[User_ID]
,[Is_Delete]
FROM [Cfamla].[dbo].[Post_Reply]
Above are two table I want to data in the next format!
[Post_ID] ,[Post_Title]
[Post_Reply_ID],[Reply_Title]
mean In the first Row of the select statement it will show me the Post_Id that is always
After the next row... It will so all the reply of that post.
Hope I explain the question correctly.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|