Select from table where doesn't appear in another table PHP

Question

I have 2 tables, one called system_dashboard_stats (tbl1) and another called user_dashboard_stats (tbl2). I want to display all rows from tbl1 that dont appear in tbl2.

So far, from looking i've found the below code, however it doesnt seem to be working as I currently see all rows from the DB.

$result11=mysql_query("SELECT * FROM system_dashboard_stats WHERE id NOT IN (SELECT id FROM user_dashboard_stats)")or die('Error' . mysql_error());

update you question and show the table columns name for both the tables — ScaisEdge
– ScaisEdge, Commented Jul 23, 2016 at 20:09
See our exciting documentation page here that we so proudly present to everyone ... show create table xyz — Drew
– Drew, Commented Jul 23, 2016 at 20:11

Akin Williams · Accepted Answer · 2016-07-23 20:09:04Z

SELECT * FROM system_dashboard_stats LEFT JOIN user_dashboard_stats ON system_dashboard_stats.pk = user_dashboard_stats.fk WHERE user_dashboard_stats.fk IS NULL;

Jahid Mahmud · Accepted Answer · 2016-07-23 20:19:20Z

You should write this

$result11=mysql_query("SELECT * FROM system_dashboard_stats LEFT JOIN user_dashboard_stats ON system_dashboard_stats.pk = user_dashboard_stats.fk WHERE user_dashboard_stats.fk IS NULL")or die('Error' . mysql_error());

Collectives™ on Stack Overflow

Select from table where doesn't appear in another table PHP

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related