SELECT * FROM Orders WHERE Orders.product_id = Products.id;

Error Code: 1054. Unknown column 'Products.id' in 'where clause'

SHOW CREATE TABLE Products;

Products, CREATE TABLE `Products` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`description` varchar(100) DEFAULT NULL,
`details` text,
`warehouse` char(100),
`price` decimal(8,2) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8

SELECT * FROM Orders, Products WHERE Orders.product_id = Products.id AND customer_id IS NOT NULL;