Hi friends, I have a table A that I need to join to one of 4 source tables. The weird thing is that the source tables house different months... (same format and structure). So the tables houses months as follows: Table months available A 1,5,9 B 2,6,10 C 3,7,11 D 4,8,12 I have table F like: ID START_date END_date 12 2020-06-01 2020-08-30 Which i need to left join to one of the below tables where the value appears right before the end_Date Table A ID date cost 12 2020-01-15 5.00 12 2020-05-20 6.00 Table b ID date cost 12 2020-02-15 5.00 12 2020-06-20 6.00 Table c ID date cost 12 2020-03-15 5.00 12 2020-11-20 6.00 Table D ID date cost 12 2020-04-15 5.00 12 2020-08-12 15.00 The join should give me because table D has the date and value right before the end_date in Table F ID START_date END_Date Date Cost 12 2020-06-01 2020-08-30 2020-08-12 15.00 A. How to do the join where the query picks the right table? the tables are huge and I read that using the union function may not be ideal even in a pass through. Also the tables will have multiple values in the same month so i need to pick the cost that was recorded right before the end_Date Any suggestions would be incredibly helpful Thanks,
... View more