how to join table haivng data type nvarchar in sql server

Posted by Shanky11 under Sql Server on 9/20/2013 | Points: 10 | Views : 1438 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts