how to compare one column values of table with another table multiple column values

Posted by Raj_chennai under Sql Server on 1/17/2012 | Points: 10 | Views : 1626 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

a table contains customer complaint feedback in one column and then another table contains product details. i need to match up complaint feedback column with product details table multiple columns such as product name,product id,product model

raj

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Naraayanan on: 2/1/2012 [Member] Starter | Points: 25

0	Hi Raj, map the Two tables like this, Customer Complaint and Feedback against for Product ID. If you table like this, tbl_productfeedback Columns: ProductId CustomerID Complaints Feedback tbl_Productdetails Columns: ProductId ProductName ProductModel So your query likes this Select distinct a.ProductId,a.ProductName,a.productModel,b.complaints,b.Feedback from tbl_productfeedback b,tbl_Productdetails a where a.ProductId=b.productId order by a.ProductId I hope this will help you. Regards, Lakshmi Naraayanan.S http://dotnettechrocks.blogspot.in/ http://abaprocker.blogspot.com/ Raj_chennai, if this helps please login to Mark As Answer. \| Alert Moderator

Hi Raj,
map the Two tables like this,
Customer Complaint and Feedback against for Product ID.
If you table like this,
tbl_productfeedback
Columns:
ProductId
CustomerID
Complaints
Feedback
tbl_Productdetails
Columns:
ProductId
ProductName
ProductModel

So your query likes this

Select distinct a.ProductId,a.ProductName,a.productModel,b.complaints,b.Feedback from  tbl_productfeedback b,tbl_Productdetails a where a.ProductId=b.productId order by a.ProductId

I hope this will help you.

Regards,
Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
http://abaprocker.blogspot.com/

Raj_chennai, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts

Why do we need default column values in SQL Server? (1)Updated
Can we create Primary Key on more than one column? (1)Updated
Integrated Web Service with Mule ESB (0)Updated
Display html and data on pageload in mvc using angular js (0)New
Is it necessary to have a Primary Key on the table? (1)Updated
How can i use two app.js files in single AnuglarJS application (0)
Can we have a functionality of Primary Key without creating a Primary Key? (1)
When to use Interface and when to use Abstract? (1)
More ...