I need to get this SQL:

SELECT DISTINCT node.nid, content_field_instructions_reference.field_instructions_reference_nid 
FROM node AS node INNER JOIN content_field_instructions_reference AS content_field_instructions_reference 
ON node.nid = content_field_instructions_reference.nid 
WHERE content_field_instructions_reference.nid = 139;

I'm creating a views argument - http://drupalbin.com/2120, but I get an error. The data next to ON is missing.

...ON . = content_field_instructions_reference. WHERE...

Comments

amitaibu’s picture