This preview shows page 1. Sign up to view the full content.
Unformatted text preview: where (shippostalcode = '5020' or shippostalcode='5022') and employeeid =4 order by shippeddate desc 5. select companyname, lastname,firstname, shippeddate, shipcity, shipcountry from northwinds.orders, northwinds.employees, northwinds.customers where orders.customerid=customers.customerid and orders.employeeid=employees.employeeid and (shippostalcode = '5020' or shippostalcode='5022') and orders.employeeid ='4' order by shippeddate desc...
View Full Document
- Spring '12