Author |
Topic |
kiran.J
Starting Member
11 Posts |
Posted - 2008-02-01 : 05:30:27
|
how can i select phone number from two tables |
|
sunil
Constraint Violating Yak Guru
282 Posts |
Posted - 2008-02-01 : 05:32:29
|
What tables you are referring to? Provide some DDL and expected output to get any help here from forum users.Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
|
kiran.J
Starting Member
11 Posts |
Posted - 2008-02-01 : 05:34:09
|
how can i update gender male to m using select statement |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-02-01 : 05:37:30
|
well, given the generic nature of the question i would have to reply equally generically... i'd do it with a case statement.if you give examples etc as requested we could help moreEm |
|
|
kiran.J
Starting Member
11 Posts |
Posted - 2008-02-01 : 05:49:34
|
i have table gendermfi want change m to maleand f -femaleusing selct statement |
|
|
kiran.J
Starting Member
11 Posts |
Posted - 2008-02-01 : 05:51:14
|
i have 2 tables emp and phonei was select phone numer and empname using primarykey as empno |
|
|
sunil
Constraint Violating Yak Guru
282 Posts |
Posted - 2008-02-01 : 05:54:29
|
Do you have one requirement or many ? Every time you post, you are coming up with different thing. Please see this post in same thread on 02/01/2008 : 05:32:29 to get any help. If you don;t follow, I'm sorry but no one can help you. Hope you understand this. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-02-01 : 08:16:57
|
please constraint your self into one problem / question per thread. If you mix 2 question in the same thread, you are confusing others who are trying to help you. KH[spoiler]Time is always against us[/spoiler] |
|
|
X002548
Not Just a Number
15586 Posts |
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-02-01 : 08:58:44
|
i gave up thinking about it when i tried to decide why one would need a TABLE for gender? does that mean M, F are columns? ...i need another coffeeEm |
|
|
kiran.J
Starting Member
11 Posts |
Posted - 2008-02-02 : 00:16:32
|
ya.i have table emp in that table column gender in gender i have male and femalewhen i updete that two fields male to m and female to m |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-02 : 00:20:15
|
UPDATE empSET gender = CASE WHEN gender='m' THEN 'male' WHEN gender='f' THEN 'female' END |
|
|
kiran.J
Starting Member
11 Posts |
Posted - 2008-02-02 : 00:30:24
|
thanq |
|
|
kiran.J
Starting Member
11 Posts |
Posted - 2008-02-02 : 00:31:43
|
how can i select empname only 3 characters |
|
|
|