本文为本人学习书籍《MySQL必知必会》笔记系列,欢迎持续关注,有问题随时留言评论,一起探讨学习~ 16 高级联结 16.1 使用表别:可以缩短语句,单条SELECT多次使用相同表 SELECT p.Name AS p_name, c.Name AS c_name, b.Name AS b_name, Price1, Model FROM product AS p,product_category AS c,brand AS b WHERE p.CategoryId=c.Id AND p.BrandId=b.Id AND c.Id=615432