I need a little help finishing this SQL command. Here are my tables and fields.
1. table_files a. file_id
2. table_authors a. author_id
Table #2 is a list of registered authors, and Table #1 is a list of the files they have submitted. I would like to write a query to gather all of the authors who's author_id is GREATER THAN 35 and who have submitted more than 0 files to the other table.
Something like this, but I dont know how to write it exactly:
"SELECT author_name FROM table_authors, table_files WHERE author_id > 35 AND count(table_files.file_author) > 0"
That last part about counting if the author has more than 0 files in the table_files is what is throwing me off. This will be in PHP if that matters. Help?