Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jennifer_ann
Starting Member
8 Posts |
 Posted - 2006-04-10 : 13:02:25
|
| Table Name: StoryTable Columns: user_id, date, name, yr_left, city_origin, country_origin, yr_arrival, city_arrival, state_arrival, address, city, state, zip, AorV (audio or video), filename, approvedI need to create two queries. One based on date in descending order, and one based on country_origin in alphabetical order. For both of these queries, the approved field has to = Y for yes, and when I return results I need it to return everything in the table EXCEPT for the name.I'm a beginner at SQL queries so I was hoping someone could shed some light and help me??? Thanks a bunch! |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
|
|
|
|
|
|
|
Complex Query