SQLTeam.com | Weblogs | Forums

Newby - a question about working with two tables

Hi

Can anyone help with this? The amount is in a different table from the other information

Write an SQL statement to retrieve the customer ID, first name, last name and order amount for customers from USA who made orders amounting 350 and over.

You can join tables to retrieve the amount. You can jump in rond 30 minutes.

Select a.customer_id, a.last_name,a.first_name, b.country, b.amount
from table A
left join table b on a.customer_id=b.customer_id
where b.country ="USA"
having amount >=350

having more than 1 record .. sum(amount)

filters if any

Thanks, this worked, I had to omit having and use and instead.