I'm still new at python, please help.

can you use python pyodbc module to connect to MS SQL Server to query out with inner join a new table, and dump it into a folder as a stand alone .csv or .dbf table with all the columns/field? I have used pyodbc to query out result before, but I want to take it to another level. Can you guys point me to some resources or help. Thanks,!!