Aug-31-2018, 08:23 PM
I also tried:
sqlite> SELECT StateCd, CountyName, PlaceCd, StateAbbr, PlaceName, PlaceType, Fstat FROM places ...> LEFT JOIN county ON (places.StateCd = county.StateCd, places.CountyName = county.CountyName); Error: ambiguous column name: StateCddifferent column, same error