Need help w/ SQL query in phpMyAdmin

[audradh]

Hey All
I am trying to extract to Excel the following information regarding active products in my database:

• Name
• Description
• image URL
• lowest price (ie sale/special price where applicable, regular price otherwise)
• URL

My SQL skills don't really exist, but I'm capable of following basic tutorials. So, taking things one step at a time...

I have managed the 1st two for all products w/ this:

SELECT products_name, products_description
FROM products_description

I have managed the image filename and regular price w/ this:

SELECT products_image, products_price
FROM products

What I cannot figure now is how to put those 2 queries together to extract those 4 pieces of information at one time.

I figure that is the next step, although I'm sure as I progress I will need a little more prodding

Appreciate any nudges in the right direction!
Peace,
Audra