I am trying to run an sql select statement while selecting all records
from 3 different files, but I get an error "too many columns so I wanted to just select a couple different fields from each table instead of all records from each table my old syntax was "select * from table1,table2,table3 where table1.field1=table2.field1 and table1.field1=table3.field1" what is the syntax for just selecting field1 from table1,2, & 3 ?

Thanks For Your Help
Stephen J. Hunt