I am new to writing a stored procedure so any help would be appreciated. I want to fetch a list of a list from 2 tables. I have a folder.id which points to doc.parent_id. I want to get a list of documents where doc.create_date is 30 days or older. It does not need to be a stored procedure but I want to know how using SQL without writing a program.
Thanks!
Thanks!