Table 1
Seq#,TransType,LocnNum,TankNum,Date,TimeStart,TimeEnd,TktVol,AltVol,TotalSrt,TotalEnd,Driver,Trip,Route,MeanDegC,MaxDegC,ColCd,Ccode,TestType,TrpSdate,GPSlat,GPSlon
174,0,291061000,59,141130,104945,105755,3355,0,255094551,255094551,5005,2,505,3.0,3.5,00,00,00,141130,5140600,645550
175,0,250401500,133,141130,110343,110858,760,0,255102140,255102140,5005,2,505,3.0,3.2,00,00,00,141130,5141450,647450
176,0,250400800,29,141130,115529,120130,1695,0,255119079,255119079,5005,2,505,3.7,4.2,00,00,00,141130,5147650,656150

Table 2
LocnID,TestCo#,LastVol,LocnName,LocnAdr,Lat,Lon
291061000,205,3568,Evans Marcross,,5140600,645550
250401500,205,857,Thomas And Ptns Somerset,,5141450,647450
250400800,205,1727,Thomas J  Newton House,,5147650,656150

Joined Table
Seq#,TransType,LocnNum,TankNum,Date,TimeStart,TimeEnd,TktVol,AltVol,TotalSrt,TotalEnd,Driver,Trip,Route,MeanDegC,MaxDegC,ColCd,Ccode,TestType,TrpSdate,GPSlat,GPSlon,LocnID,TestCo#,LastVol,LocnName,LocnAdr
176,0,250400800,29,141130,115529,120130,1695,0,255119079,255119079,5005,2,505,3.7,4.2,00,00,00,141130,5147650,656150,250400800,205,1727,Thomas J  Newton House,
175,0,250401500,133,141130,110343,110858,760,0,255102140,255102140,5005,2,505,3.0,3.2,00,00,00,141130,5141450,647450,250401500,205,857,Thomas And Ptns Somerset,
174,0,291061000,59,141130,104945,105755,3355,0,255094551,255094551,5005,2,505,3.0,3.5,00,00,00,141130,5140600,645550,291061000,205,3568,Evans Marcross,