SQL syntax Newbie student

Posted by sammysmall on Stack Overflow See other posts from Stack Overflow or by sammysmall
Published on 2010-04-21T19:24:35Z Indexed on 2010/04/21 19:33 UTC
Read the original article Hit count: 313

Filed under:
|
|

Describe the output of the following SQL query:

select custId, name
from customer
where region = "New York"
UNION 
select cust.custId, cust.name
from customer cust
where cust.custId IN (select cust_order.custId
from customer_order cust_order, company_employee comp_emp
where cust_order.salesEmpId = comp_emp.empId
AND comp_emp.name = 'DANIEL');

My question is: at line from customer cust

is cust referring to a column in the customer table...

This is a homework question I have identified the components leading up to this line and I think that cust is a column in the customer table... I am not asking for an overall solution just a bit of encouragement if I am on the right track...

© Stack Overflow or respective owner

Related posts about sql

Related posts about syntax