I have two related tables, template and templine. They both have a template field that contains the template name and that's how they relate to each other. I need to select records in templine based on a field that appears only in template. Something like this:
select * from templine where template.type='M'
I don't know how to express template.type (which is supposed to find the type field in the template table) properly so that the query will run. Thanks.