Link by dates

[#1]

Hi all,

I hope the community experts can help me on this.

I Have the follow situation:

Table SatO2

Patient ID     Date                    SatO2

1234           05/10 10:00:00          98

1234           05/10 10:00:30          98

1234           05/10 10:01:00          97

......

1234           05/10 11:00:00          99

Table FiO2

Patient ID     Date               FiO2

1234           05/10 09:30:00     21

1234           05/10 10:15:00     25

I need to join the tables based on the date so that the FiO2 value will value between to date/time without changing the number of registers of SatO2 table. This way:

Patient ID     Date                    SatO2   FiO2

1234           05/10 10:00:00          98      21

1234           05/10 10:00:30          98      21

1234           05/10 10:01:00          97      21

......

1234           05/10 11:00:00          99      25

I am stucked to join the two tables without a complete FK

I would really apreciate your help.

An working example would be great ! !

Regards,

Itamar