根据另一个表中的存在，从表中选择

Question

Guys I want to Select from table articles depending if code is in table called inStock . So for example if I have in column code in table inStock 224 I need to Select * FROM articles having that code and for every item same. Any help?

This is table inStock

And this is table articles

Answer 1

Try with the following query: with inner join you can get this as code need to present in both table, hopefully you'll get your desired ans

select a.id,a.code,a.name,a.description,a.amount,a.color,b.price
from articles a inner join instock b
on a.code=b.code