how to join table haivng data type nvarchar in sql server

Posted by Shanky11 under Sql Server on 9/20/2013 | Points: 10 | Views : 741 | Status : [Member] | Replies : 1
select orders.orderid,temporder.pname,temporder.price,temporder.pid from orders inner join temporder on orders.ipaddress=temporder.ipaddress

ipaddress datatype is nvarchar

on orders.ipaddress=temporder.ipaddress this condition is not working means
temporder.ipaddress is not coming




Responses

Posted by: Bandi on: 9/20/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
what is the problem here orders.ipaddress=temporder.ipaddress ?
temporder.ipaddress is not coming means you doesn't have data in temporder table ?
What is the datatype of orders.ipaddress?


Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

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

Login to post response