subquery

Question

subquery

adhamihab

Newbie

Points: 9
More actions
March 2, 2014 at 1:25 am

#282964

how can i write this query using subquery and keeping the from as orders only.
USE northwind
SELECT max(OrderID) as OrderID
FROM Orders join Employees
on Orders.EmployeeID = Employees.EmployeeID
join Customers
on Orders.CustomerID = Customers.CustomerID
WHERE Employees.LastName = 'Peacock'
and
Customers.Phone = '(5) 555-3932'

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004704 More actions · Answer 1

adhamihab (3/2/2014)
how can i write this query using subquery and keeping the from as orders only.
USE northwind
SELECT max(OrderID) as OrderID
FROM Orders join Employees
on Orders.EmployeeID = Employees.EmployeeID
join Customers
on Orders.CustomerID = Customers.CustomerID
WHERE Employees.LastName = 'Peacock'
and
Customers.Phone = '(5) 555-3932'

I have to ask, why would you want to do such a thing? What problem are you having with the way it's written?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)