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 |
|
abc
Starting Member
48 Posts |
 Posted - 2002-05-24 : 23:56:57
|
| Hello,I got a trouble need your help. Following are my tables:country table city table Market------------ ------------ ------------country_ID city_ID Market_IDcountry_name country_ID City_ID city_name Country_ID Market_nameIn common I shoudn't have country_ID in market_name, because I can extract Country_name and City_name through city_id in market table. But sometimes, the market only contains country_ID, so I have to include country_ID column in market table. I wonder if there is another way to do that. If no, how I can select the country_name if the city_name is Null in a select use If condition.Thank for helping me.Thanks for your attention |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-05-25 : 00:46:45
|
| Check for Case in BOL .IF you still have any issues with it, come and postback.would recommend a Forum Search too on Case-------------------------------------------------------------- |
 |
|
|
|
|
|
How to use if conditon in a select query