New Topic/Question
Reply
SELECT VendorName, VendorCity, VendorState
FROM Vendors
(SELECT DISTINCT VendorCity
FROM Vendors
ORDER BY VendorName)
IM LOST HELP
3 Replies - 843 Views - Last Post: 27 March 2012 - 01:10 PM
#1
B2SALONWEBDESIGN
- New D.I.C Head
Reputation: 0
- Posts: 8
- Joined: 26-January 11
select statement returns vendor, city, state - in unique city/state
Posted 27 March 2012 - 11:50 AM
THIS IS WHAT I HAVE THUS FAR:
SELECT VendorName, VendorCity, VendorState
FROM Vendors
(SELECT DISTINCT VendorCity
FROM Vendors
ORDER BY VendorName)
IM LOST HELP
SELECT VendorName, VendorCity, VendorState
FROM Vendors
(SELECT DISTINCT VendorCity
FROM Vendors
ORDER BY VendorName)
IM LOST HELP
Is This A Good Question/Topic?
0
MultiQuoteReplies To: select statement returns vendor, city, state - in unique city/state
#3
B2SALONWEBDESIGN
- New D.I.C Head
Reputation: 0
- Posts: 8
- Joined: 26-January 11
Re: select statement returns vendor, city, state - in unique city/state
Posted 27 March 2012 - 01:08 PM
modi123_1, on 27 March 2012 - 12:00 PM, said:
It looks like you forgot to select a question and insert it into your post.
I need a where statement that does the count but i am not sure how to go about coding it, can you suggest a route or perhaps an informative link.
thanks so much.
Was This Post Helpful?
0
Page 1 of 1
|
|
| 