As the title suggests, does an equal to the lateral join exist in redshift? I haven't run into a situation where it might be necessary yet, but it seems hard to imagine replicating the functionality of a lateral join if I needed to with what I know now.