join two tables but want one matching columns instead of showing it separately sql server 2008
Posted
by amby
on Stack Overflow
See other posts from Stack Overflow
or by amby
Published on 2010-04-16T21:04:55Z
Indexed on
2010/04/16
21:13 UTC
Read the original article
Hit count: 130
tsql
|sql-server
Hi i want to display join result of two tables but don't want to show matching column separately. I want it one instead of two. so please tell me what query should i use for this. I m using sql server 2008 and my query is like: select * from Customer_Order, optRelation where Customer_Order.orderNumber = optRelation.orderNumber AND optRelation.orderNumber = 21. please reply soon
© Stack Overflow or respective owner