Re: help with my sql

In article <cTV89.7$6U3.4_at_nwrddc01.gnilink.net>, "Joe says...
>
>I have two tables.
>table A has a date column, and a date_key,
>table B has a year(varchar2) , month(varchar2) , day(varchar2),
>hour(varchar2),minute(varchar2) column, and a date_key
>
>I need to do something like this
>
>update table A
>set A.date_key = B.date_key
>where
>B.year = to_char(A.date,'yyyy')
>and B.month = to_char(A.date,'mm')
>and B.day = to_char(A.date,'dd')
>and B.hour = to_char(A.date,'hh24')
>and B.minute = to_char(A.date,'mi')
>
>How could I do that?
>
>Thanks for your help
>
>

update A
  set date_key = (select date_key

                    from b
                   where B.year = to_char(A.date,'yyyy')
                     and B.month = to_char(A.date,'mm')
                     and B.day = to_char(A.date,'dd')
                     and B.hour = to_char(A.date,'hh24')
                     and B.minute = to_char(A.date,'mi'))
where exists (select date_key 
                    from b
                   where B.year = to_char(A.date,'yyyy')
                     and B.month = to_char(A.date,'mm')
                     and B.day = to_char(A.date,'dd')
                     and B.hour = to_char(A.date,'hh24')
                     and B.minute = to_char(A.date,'mi'))


                     

>
>

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp