Performing a SQL query to get cocktails by ingredient ID on many-to-many relationship

Published: 14/01/2019
Performing a SQL query to get cocktails by ingredient ID on many-to-many relationship
Source: STACKOVERFLOW.COM

I need help creating a SQL query that will return a cocktail from a database, given that I have supplied all the ingredients that go into that cocktail So for example, I want the "Gin and Tonic" row to return only if I have supplied the correct ids for Gin (id is 1) and Tonic (id is 2). I I only supply "Tonic," I shouldn't get back the row I'm using SQLAlchemy and Flask, but I'm still havin

Read more
Related news
Comment
FACEBOOK