how to join table haivng data type nvarchar in sql server

Posted by Shanky11 under Sql Server on 9/20/2013 | Points: 10 | Views : 695 | Status : [Member] | Replies : 1
select orders.orderid,temporder.pname,temporder.price, 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


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

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

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

Login to post response