Loading

Join 3 tables and fetch for latest record from 3rd table

Chaitanya

10y1.2k

Join 3 tables and fetch for latest record from 3rd table if not exists display latest from 2nd table

Please find the fiddle here

Fiddle

My requirement is I need to display the latest record from 3rd table if exists based on first table ID and second table ID, if not I would like to display the latest record from second table. I have given the sample tables and the query I have written but i am not getting the actual result as per my need so some one can help me

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Khan Abrar Ahmed9y ago
Hi Join all 3 table and order by the using date in desc order and get top 1 record