Re: [sqlalchemy] Help writing query - "where most recent is true, but any other is false"

On Wed, Dec 13, 2017 at 10:24 PM, Leo Simmons wrote: > I have a table `special_product_list` and a table > `special_product_historical_details_list` that holds information of products > over time, where there's a record in the history table every day for every > product. > > I want

[sqlalchemy] Help writing query - "where most recent is true, but any other is false"

I have a table `special_product_list` and a table `special_product_historical_details_list` that holds information of products over time, where there's a record in the history table every day for every product. I want to write a query to select all products from `special_product_list` that