ݺߣ

ݺߣShare a Scribd company logo

ng6b8.docx

•
•
Jeff Smith
Jeff Smith

This SQL query selects all properties from the alf_node_properties table where the actual type is 21 and there is no matching content data in the alf_content_data table for the long value property. It performs a left join to check for null values in the alf_content_data table id field.

1 of 1
select * from alf_node_properties np left join alf_content_data cd on (cd.id = np.long_value) where np.actual_type_n = 21 and cd.id is null;

More Related Content

ng6b8.docx

  • 1. select * from alf_node_properties np left join alf_content_data cd on (cd.id = np.long_value) where np.actual_type_n = 21 and cd.id is null;