際際滷

際際滷Share a Scribd company logo

5ljdb.docx

Jeff Smith
Jeff Smith

This SQL query selects all properties from the alf_node_properties table where the actual type is equal to 21 and there is no matching content data in the alf_content_data table for the long value property.

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

5ljdb.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;