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".
max(vid) AS vid, nid
September 18, 2022 at 11:45 am
Hello ,
Thank you so much, solved.
October 18, 2022 at 7:04 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply