Select from multiple tables
I have two tables: products and products_description. They have different number of columns. I want to select information from both tables with a single query. When I try the query below, I get a 1064 error. Can you help?
SELECT `products.products_id`, `products.products_image`, `products.products_price`, 'products_description.products_name', 'products_description.products_desc'
FROM `products`, 'products_description'
where`products.products_id` = `products_description.products_id`;