SQL Statement

[Guest]

Please help!!!

I am trying to write an SQL command that will display a
all the data from table A and data from column 1 in table
B.

The two tables are linked in a one to many realtionship,
with table A having multiple copies of data held in column
1 of Table B.

Thanks

Nick

 

[Bill Taylor]

SELECT TableA.FieldMany
FROM TableA INNER JOIN TableB ON TableA.FieldMany = TableB.FieldOne;