How to displaying data from database [MySQL Query]

Question

I have two tables that are related

that table is teachers and attendance

that 2 tables, is related with field teachers.id and attendance.id_teachers

now my question is, how to displaying teachers data which is that teachers data (teachers.id) is not listed in attendance table

i hope you guys understand what i'm hoping for...

I appreciate every answer

thanks

Below link might help: stackoverflow.com/questions/12048633/… — Ramkrushna26
– Ramkrushna26, Commented Nov 20, 2016 at 13:09

user4266998 · Accepted Answer · 2016-11-20 13:19:03Z

0

You can try with this:

SELECT * FROM teachers WHERE id NOT IN (SELECT id_teachers FROM attendance)

answered Nov 20, 2016 at 13:19

user4266998

Sign up to request clarification or add additional context in comments.

Comments

DevSingh · Accepted Answer · 2016-11-20 13:23:46Z

0

IN clause is your friend here. You may want to read-up on this. Following query should give the result:

select * from teachers where id not in (select id_teachers from attendance)

answered Nov 20, 2016 at 13:23

DevSingh

112 bronze badges