inner join query with three tables.

[fabiobarreto10]

Gentlemen, I am struggling to make an inner join query with three tables.



SELECT TblComentários.Comentários, AuditTable.RecordPrimaryKey, AuditTable.FieldName, AuditTable.OriginalValue,
AuditTable.NewValue, AuditTable.DateTimeStamp,TblPassosStatus.Passo


Table field
AuditTable RecordPrimaryKey
TblComentários CodPassosStatus
TblPassosStatus CodPassosStatus

must do the inner join of the selected fields above, where the three fields below are equal.

[boblarson]

Are you attempting to write the SQL by hand? If so, why not just do it in the QBE (Query By Example) grid. It is much easier that way.

[fabiobarreto10]

Dear boblarson, thanks for replying. honestly, I do not know how you told me. I have this query that works perfectly:

SELECT TblComentários.Comentários, AuditTable.RecordPrimaryKey, AuditTable.FieldName, AuditTable.OriginalValue, AuditTable.NewValue, AuditTable.DateTimeStamp
FROM AuditTable INNER JOIN TblComentários ON AuditTable.RecordPrimaryKey=TblComentários.CodPass osStatus;


I am trying to add one more field in another table. I'm not able to make the speech. image attachment.

Thank you.