Im rubbish MySQL joins, and need an assist please.
i have a product table and an images table. Each product has 4 images associated to it by a foreign key product id in the images table.
I need to pull out the product info (from prod table) and 1 image, can anyone help? I can it it with multiple queries, but was hoping for a cure all solution...