i have two tables named
1.LookupPageInfo and (LookupPageInfoId,pathmessageID,pagemessageID)
Now i need to write a query something like this........in the query i need to pass the pathmessageid and needs to get messagetext from Messages Table,i am not sure how i need to write the below query..can someone guide me how can i write a query......as below..
(select messagetext from Messages where MessageID=PathmessageId) as TEXT
View Complete Post