AnsweredAssumed Answered

SQL statement to get list of document names

Question asked by somersst on Apr 16, 2010
Latest reply on Apr 29, 2010 by eclose0923
I'm trying to create a SQL-statement which gives me the following information :
Filename(as uploaded)   Content-URL-Filename (bin as stored by Alfresco)

I know I need to join tables like alf_content_url & ald_node_properties, but I don't find the right key to link them.

Any help would be most welcome

Outcomes