Hi P V,
Here is an example on how you could do this:
import arcpy
from arcpy import env
env.overwriteOutput = 1
env.workspace = r"C:\temp\tables"
shapefile = r"C:\data\parcels.shp"
#loopo through tables in C:\temp\tables
for table in arcpy.ListTables("*"):
#Create a new feature layer, this will remove previous join
arcpy.MakeFeatureLayer_management(shapefile, "parcelLyr")
#Join table to feature layer
arcpy.AddJoin_management("parcelLyr", "PIN", table, "PIN")
#Retrieve table name
tableName = table.split(".")[0]
#Export joined layer to new feature clas
arcpy.FeatureClassToFeatureClass_conversion("parcelLyr", r"C:\data\ParcelData.gdb", tableName)