CODEWITHSUNDEEP
sqlitenestedunionsql
Cocoa Dev
Cocoa Dev

Reputation: 9541

Creating dynamic queries for SQLite3

I have 2 tables in a DB.

Table2 has values that would be needed for Table1

Example

Table1 has the following fields

Name FoodColor FoodSmell FoodCookingStyle

As we all know certain foods can be cooked in a variety of ways (while producing the same results). One approach is to create a new row for each variation.

Table2 would have data for FoodCookingStyle like FoodCookingStyle=1 OR FoodCookingStyle=2 OR FoodCookingStyle=3

So the result is I want to create a Query that uses the results from Table2 to produce a SQL Query that would look like

SELECT * FROM TABLE1 WHERE FoodCookingStyle=1 OR FoodCookingStyle=2 OR FoodCookingStyle=3

(only difference is I want to query table2 instead of typing out the expression).

Type of DB being used is SQLite3.

Thank you

To clarify what I meant. I need the output for table2 to be the input for table1

Upvotes: 0

Views: 639

Answers (1)

Michael Low
Michael Low

Reputation: 24506

The question is a bit confusing. Is it subqueries you're looking for ? Subquery syntax is along the lines of SELECT * FROM Table1 WHERE FoodCookingStyle IN ( SELECT FoodCookingStyle FROM Table2 WHERE FoodCookingStyle=1 OR FoodCookingStyle=2 OR FoodCookingStyle=3 )

Upvotes: 1

Related Questions