Dml join查询1个校友管理系统 [英] Dml join queries 1 alumni management system

问题描述

Write a query to display the names of the users who have posted posts and the contents of posts, sorted by name, then by post date and then by post content.

请将此查询编码发送给我。

i试用了这个。但是山雀说这是一个错误的答案。请用正确的查询编码来帮助我。



我尝试了什么：



选择user.name，post.content from user

内部加入帖子

on user.id = post.user_id

按用户名，日期（日期）排序;

kindly send me the query coding for this.
i tried out this. but tits stating it to be a wrong answer.kindly help me with the right query coding.

What I have tried:

select user.name,post.content from user
inner join post
on user.id=post.user_id
order by user.name,date(date);

推荐答案

你必须这样写：



选择user.name，post.content from user

内部加入帖子

on user.id = post.user_id

按user.name，post.date，post.content排序;

这篇关于Dml join查询1个校友管理系统的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！