I'll really appreciate help on this if anyone will do so. I'm
used to single-table stuff, but not sure the best way to
do things with multiple tables, but here goes:
Given two tables with a common "id" field, first table columns:
id
lastname
Second table columns:
id
type
content
These two queries get me what I want from each table:
select unique id from table1 where lastname='morton';
select unique id from table2 where ((type = "pie") and (content = 'apple));
What is the best way to combine these into one query?
Thanks.
Frank
