Multiple SQL Inner Join?

when I use multiple inner joins I get replicated values but there is only one record,

"Select table1.Field1, table1.field2 as QNR" & _
", table2.field1, table2.field2, table3.field1, table3.field2" & _
" from table1 Inner table2 on table1.field1" & _
" = table2.field1 Inner Join table3 on table2.field1" & _
" = table3.field1"

QNR should only show one value, but is shows the one value three times?I bind it to a list box using the following:

lstQuotationNr.BindingContext = Me.BindingContext
lstQuotationNr.DisplayMember = "QNR"
lstQuotationNr.DataSource = Dataset