Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Write a SQL statement that will return all the Sales Orders for the Salespersons’ with the name starting with ‘John’. Expand / Collapse
Author
Message
Posted Tuesday, July 2, 2013 5:58 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 29, 2013 2:56 AM
Points: 16, Visits: 20
Write a SQL statement that will return all the Sales Orders for the Salespersons’ with the name starting with ‘John’.

Below are the example tables that you will be retrieving data from:

Transactions:

* Sales Order

* Order Quantity

* Order Total

* Order Date

* SalesPersonID

* ProductID

SalesPerson

* SalesPersonID

* SalesPersonName

Product

* ProductID

* ProductName
Post #1469423
Posted Tuesday, July 2, 2013 6:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:58 AM
Points: 14,556, Visits: 38,435
the format of your question screams "copy and paste" from your homework;

That's a little frowned upon here, so lets do it right:
can you show us the query you've created so far, and explain what doesn't work, or where you are stuck?
we would love to help you master the problem, rather than do it for you;

you'll suffer later if you don't grasp this concept yourself, because later homework will certain build on top of the basics like this.


Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1469432
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse