i need to join data from 3 tables, where only 2 of them have common fields. none of them have id's. the problem is with the 3rd table. Its a long list of comments. and when i complete the statement. the columns on the left will have completed the query, but since the long column isnt done it will repeat everything until that column is done. my question is how do i join 3 tables when only 1 & 3 have common fields, and 2 & 1 have common fields?