SQL:按是和否显示表及其作业(SQL: Display the table and its job by yes and no)
这是我的表:
用户表
Id | Username | --------------- 1 | jdoe |工作表
Id | Job | ---------------- 1 | Waiter | 2 | Office | 3 | Freelance |用户工作表
Id |UserId | JobId | -------------------- 1 | 1 | 2 | 2 | 1 | 3 |如何选择此表并将其显示如下所示:
Id | Username | Waiter| Office | Freelance| ------------------------------------------- 1 | jdoe | No | Yes | Yes |This is my table:
User Table
Id | Username | --------------- 1 | jdoe |Job Table
Id | Job | ---------------- 1 | Waiter | 2 | Office | 3 | Freelance |User Job Table
Id |UserId | JobId | -------------------- 1 | 1 | 2 | 2 | 1 | 3 |How to select this table and display it to look like this below:
Id | Username | Waiter| Office | Freelance| ------------------------------------------- 1 | jdoe | No | Yes | Yes |更多推荐
发布评论