MySQL connection query

The previous query is just a random look at the results, because found that the number of each query is very small, of course, it is now. But efficiency has always been the pursuit of the programmer, I will learn more about the gap.

The first is the multiple table union, a template category category, a Template table templates, a window table Shopwin, a Window type form table type

Now you want to query a window type of 1, that is, the type=1 template information in Shopwin. Template information in the Templates table, each of these is a template information. Constraints in the Shopwin table, the Shopwin table stores the corresponding relationship between the template and type. Each one is a type and a template counterpart.

In this way, I need to connect category,template,shopwin three tables to query the information for all the templates contained in the Window Type 1 window.

1 Select template information (t.category to replace C.name) 2  from Shopwin s,template t,category c 3 where s.type=14 and s.template=t.id5   and t.category=c.id

MySQL connection query