SQL Query to list all documents and keywords

[Gregory_Garvin]

Does anyone have a SQL query that will list out all documents and all keywords for a particular document type?

Kind like what the 'Generate CSV File' menu choice with All Keywords selected does.

Any help is appreciated 

Thanks

[Eric_Beavers · Accepted solution]

Some pretty good examples in the Community Post at:

SQL Query that gives me all keywords, including datestored for 1 particular doc type (hyland.com)

[Gregory_Garvin]

Thanks Eric!