How to display a data with 0 value in mysql

Question

I have a table named tbllog, it's field is type, userid, action, datelog. The userid is a foreign key coming from tbluser. some userid in my tbllog is 0 and i can't seem to display it using these query.

SELECT * FROM tbllog INNER JOIN tbluser ON (tbluser.userid = tbllog.userid)

It does display a rows consist of non-zero userid. My question is how to display all the data from tbllog whether the userid is 0 or not?

Also this is worth reading to understand difference between joins: https://stackoverflow.com/questions/5706437/whats-the-difference-between-inner-join-left-join-right-join-and-full-join — Dmitry P., Feb 03 '16 at 12:40

score 1 · Accepted Answer · answered Feb 03 '16 at 12:45

1

Try This

SELECT * FROM tbllog 
LEFT JOIN tbluser 
ON tbluser.userid = tbllog.userid

For More Info http://dev.mysql.com/doc/refman/5.7/en/join.html

answered Feb 03 '16 at 12:45

Vipin Jain

3,686
16
35

Thanks sir. Can I marked this as an answer? @Gordon already answered it in comment. – Al bassam Feb 03 '16 at 15:04

How to display a data with 0 value in mysql

1 Answers1