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 |
|
themoney32
Starting Member
20 Posts |
 Posted - 2009-09-21 : 00:50:17
|
| I am trying to find orders that were shipped after april 1st 1998 in my database and also ones that are to brazil, I just cant seem to figure out how to show they are in brazil as well. This code works up until I use the ShipCountry IN (Brazil)...SELECT OrderDate, RequiredDate, ShippedDate FROM orders o WHERE OrderDate BETWEEN '1998-04-01 00:00:00' AND '1998-05-06 00:00:00' AND ShipCountry IN (Brazil)Any help? |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-09-21 : 01:13:34
|
| SELECT OrderDate, RequiredDate, ShippedDate FROM orders o WHERE OrderDate BETWEEN '1998-04-01 00:00:00' AND '1998-05-06 00:00:00' AND ShipCountry IN ('Brazil')Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
|
|
|
Help