View previous topic :: View next topic
|
Author |
Message |
prakash271082
New User
Joined: 09 Sep 2005 Posts: 53
|
|
|
|
Hi Friends,
I have a following table say T1,
Amt. Type ( Type can have only R or E )
200 R
150 E
.........
.........
I have created another table, T2 on which there are 2 columns to hold the values from T1 based on Type field i.e if Type value = 'R' the corresponding Amt. value ( 200 ) should be inserted in to col1 in T2, similarly if Type value = 'E' its corresponding Amt. Value ( 150 ) should be inserted in to col2 in T2.
Need code to accomplish this ?
Thanx & Regards,
Prakash. K |
|
Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
What a big deal in that..?
You told that the table T1.TYPE can contain only R & E.
So just a simple query should serve your purpose.
INSERT INTO T2 SELECT * FROM T1.
if you think, there is no check constraint on T1.TYPE and contain others too. Then just filter it by WHERE predicate.
INSERT INTO T2 SELECT * FROM T1 where TYPE IN ('R','E') |
|
Back to top |
|
|
|