I have 3 tables that I need to join. That part I can do. What I don't know how to do is that one of the tables can have multiple records and what I need is the last record entered. Here are the relavent table definitions:
TableA TableB TableC
----------- ----------- ----------
IDA IDB IDC
Field1 IDA IDA
Field2 FieldA FieldZ
TableA and TableB will only have one record for IDA but TableC can have multple records with IDA. I need the most recent record from TableC.
Here is the SQL that I use to Join the 3 tables.
SELECT TableA.*, TableB.*, TableC.*
INNER JOIN TableB
ON TableA.IDA = TableB.IDA JOIN TablceC
ON TableB.IDA = TableC.IDA
Any help is greatly appreciated!