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: 387
        
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