select from 2 different mysql tables
<p>I have 2 tables one for products and one for images i need to get all products with its related images. and all products with only one image for each</p>

<p><a href="https://i.stack.imgur.com/lTQoY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lTQoY.png" alt="enter image description here"></a></p>