3 Replies - 1078 Views - Last Post: 27 March 2012 - 01:10 PM

#1 B2SALONWEBDESIGN  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • 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 :)
Is This A Good Question/Topic? 0
  • +

Replies To: select statement returns vendor, city, state - in unique city/state

#2 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9366
  • View blog
  • Posts: 35,187
  • Joined: 12-June 08

Re: select statement returns vendor, city, state - in unique city/state

Posted 27 March 2012 - 12:00 PM

It looks like you forgot to select a question and insert it into your post.
Was This Post Helpful? 1
  • +
  • -

#3 B2SALONWEBDESIGN  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 8
  • Joined: 26-January 11

Re: select statement returns vendor, city, state - in unique city/state

Posted 27 March 2012 - 01:08 PM

View Postmodi123_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
  • +
  • -

#4 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9366
  • View blog
  • Posts: 35,187
  • Joined: 12-June 08

Re: select statement returns vendor, city, state - in unique city/state

Posted 27 March 2012 - 01:10 PM

... a where that does what?!
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1