InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 07:09:17 GMT20http://www.sqlservercentral.com/Forums/Topic1260703-334-1.aspxYou posted this query in two forums about jobs???I will attempt to respond to your question.[quote]In the below coding no compilation error but using this quary i am not getting the answer please give me the answer for this below quary[/quote]I am not sure what the answer is because I don't know what the question is.Fri, 02 Mar 2012 07:34:53 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1260703-334-1.aspxits like you are not getting any result after firing above query?Fri, 02 Mar 2012 06:58:13 GMTmanukumarhttp://www.sqlservercentral.com/Forums/Topic1260703-334-1.aspxHi sir,In the below coding no compilation error but using this quary i am not getting the answer please give me the answer for this below quaryselect ProductID,Name,NameResults.Rank as NameRank,DescriptionResults.Rank as DescriptionRankfrom Productleft outer joincontainstable(Product,Name, 'Formsof(INFLECTIONAL,red)and FORMSOF(INFLECTIONAL,blue)', language 'english') as NameResultson Product.ProductID=NameResults.[key]left outer joincontainstable(Product,Description, 'Formsof(INFLECTIONAL,red)and FORMSOF(INFLECTIONAL,blue)', language 'english') as DescriptionResultson Product.ProductID=DescriptionResults.[key]where(NameResults.Rank is not null)and(DescriptionResults.Rank is not null)order by(isnull(NameResults.Rank,0)* 3 + isnull(DescriptionResults.Rank,0))descFri, 02 Mar 2012 03:51:57 GMTashwiniranju14