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: 131

Filed under:
|

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

Related posts about tsql

Related posts about sql-server