depart_dup
dept_mandup
i'm using the following code but i'm getting zero rows in return
SELECT
m.dept_no, m.emp_no, d.dept_name
FROM
dept_mandup m
INNER JOIN
depart_dup d ON m.dept_no = d.dept_name
ORDER BY m.dept_no;
output
Asked
Active
Viewed 41 times
-3
Barmar
- 669,327
- 51
- 454
- 560
Yash Shrivastava
- 1
- 1
- 2
-
Please share the table and data details here. Image not allowed. – Amit Verma May 19 '22 at 13:44
-
2Why are you joining the number to a name? Join on the department numbers. – Barmar May 19 '22 at 13:45
-
Swap `depart_dup d ON m.dept_no = d.dept_name` to `depart_dup d using(dept_no)` – user3783243 May 19 '22 at 13:50
-
@Barmar thanks understood my mistake – Yash Shrivastava May 19 '22 at 14:07
-
@user3783243 thanks your change worked too though i'm unable to understand the logic behind it as i'm a novice kindly explain if you can.. – Yash Shrivastava May 19 '22 at 14:08
-
`using` is the same as `on` but doesn't require defining the relationship. It will join on the two fields with the same name. Can read more here, https://stackoverflow.com/a/11367066/3783243 – user3783243 May 19 '22 at 14:23