MySQL query in two tables

Question

Is possible to get all items with name = "A" AND status = 1? Name is in table items and status is in table status.

Something like SELECT * FROM items WHERE name = "A" AND id AS status.itemid = 1 but this does not work.

Db structure:

TABLE items:

id      name
1       A
2       A
3       B

TABLE status:

itemid      status
1           1
2           1
3           2

SELECT * FROM items WHERE name = "A" AND status = 1 ? ah 2 tables nvm — Drew
– Drew, Commented Jul 17, 2016 at 21:24
Thanks but status column is not in items table. It is in sigle table with same key. — JackDavis
– JackDavis, Commented Jul 17, 2016 at 21:25

ScaisEdge · Accepted Answer · 2016-07-17 21:25:50Z

1

use inner join

select a.name, b.status 
from  items as a 
inner join status as b  on a.id = b.itemid
where a.name ='A' and b.status =1;

answered Jul 17, 2016 at 21:25

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

2 Comments

JackDavis Over a year ago

thank you very much and sorry for stupid question but this is my first time when i have to use inner join so now I will know next time :)

ScaisEdge Over a year ago

Do not apologize .. I do not think there are stupid questions in this area .. just some things already have the answers others are still trying and SO is a step in this very popular search .. anyway if my answer is right .. please mark it as accepted .

Collectives™ on Stack Overflow

MySQL query in two tables

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related