Hi all,

I am relatively new to using Postgresql and I am having a hard time understanding LEFT JOIN. I'm not sure if this is the right forum for this but could somebody help me figure out how to add a left join to this query? Whenever I bring in the public.price_adjustment table, my query returns no results. I'm pretty sure it has to do with the fact that the product.id that I have in the WHERE clause does not have a Date_start or a Date_Finish in the database so it is excluding the data entirely. 

Please Login or Register  to view this content.