Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

T-SQL Query: Select a row in one table based on data in another table

Avatar of tcianflone
tcianfloneFlag for United States of America asked on
Microsoft SQL Server 2008
2 Comments1 Solution519 ViewsLast Modified:
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.
Avatar of Egilas76
Egilas76Flag of Norway image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answers