sql查询

SELECT aid FROM dy_article_field WHERE length(slide) > 10 AND length(slide) < 120

SELECT title FROM dy_article WHERE id = (SELECT aid FROM dy_article_field WHERE length(slide) > 10 AND length(slide) < 120);

SELECT title FROM dy_article left join dy_article_field on dy_article.id = dy_article_field.(SELECT aid FROM dy_article_field WHERE length(slide) > 10 AND length(slide) < 120);

select news.id,news.news_type_id,news_type .type_name,news.title
from news
left join news_type on news.news_type_id=news_type .type_id
where news.news_type_id =1

select dy_article_field.aid,dy_article_field.slide from dy_article_field left join dy_article on dy_article_field.aid=dy_article.id WHERE length(slide) > 10 AND length(slide) < 110;