Re: [SQL] Design and Question

On 10 jul 2008, at 14.50, PostgreSQL Admin wrote: How do I combine the two in a query? If you're looking for recipes that match *either* criterion (season *or* diet), you could add the two subqueries generating the ids using UNION or UNION ALL: SELECT title FROM recipes WHERE id IN ( SEL

[SQL] Design and Question

Hi, I have BOTH a sql AND db design question. I'm creating a cookbook DB with have broken the table into this: RECIPE TABLE Column | Type | Modifiers ---+--+-- id | integer | not null default nextval('r