I want to write a python script which :
1. fetch textual data from a table in a SQL database and create a local table (.dbf?) called TABLE A
2. join this textual data (TABLE A) to an existing .shp file (objects) using a unique ID and output this data into a new .shp.
I am a complete novice in python but just need a push in the right direction (commands & summary of steps) and I should be able to piece it all together.