Join Properties in a Select Query

[George Too]

I have table1 with fields 'project', field1, field2, field3 and table2 with fields 'project', fieldA, fieldB, fieldC. I need a query that has all fields from table1 and only fieldA from table2. What kind of join property should it have in order for me NOT to have duplicates? 'project' field in both tables has the same values.

As always, any help is greatly appreciated. Thanks.

 

[Guus2005]

select distinct table1.project, table1.field1, table1.field2, table2.field23 from table1 inner join table2 on table1.project = table2.project

Enjoy!

 

[George Too]

Excellent Guus2005, that did it. I'm forever in debt.