Query Max Values
1 Topic
Correct the Code
Hello , Would you please correct the code as I am receiving the below error : select * from openquery(DRUPAL,'select o.* from (select max(vid), nid from content_type_irb_application_form group by nid) i inner join content_type_irb_application_form o on o.nid = i.nid and o.vid = i.vid') Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing the query "select o.* from (select max(vid), nid from content_type_irb_application_form group by nid) i inner join content_type_irb_application_form o on o.nid = i.nid and o.vid = i.vid" for execution against OLE DB provider "MSDASQL" for linked server "DRUPAL".Solved1.2KViews0likes2Comments