CREATE TABLE products (
productID INT AUTO_INCREMENT PRIMARY KEY,
product_price DECIMAL 11,2)
CREATE TABLE product_images (
imgID INT AUTO_INCREMENT PRIMARY KEY,
CONSTRAINT FOREIGN KEY productID REFERENCES products(productID)
It's called a "one to many table". One productID can have many imgID records.
It is *VERY VERY* standard database design. Read up on NORMALIZATION.
No, it doesn't lead to "very complicated SQL statements." It leads to quite common JOINs.