SQL
◆SQL select keytable.key1 ,keytable.key2 ,(select aaa.aaavalue from (select '2008-6-27' key1 ,11111 key2 ,105 aaavalue from dual) aaa where aaa.key1 = keytable.key1 and aaa.key2 = keytable.key2) aaavalue ,(select bbb.aaavalue from (select …
◆SQL select keytable.key1 ,keytable.key2 ,(select aaa.aaavalue from (select '2008-6-27' key1 ,11111 key2 ,105 aaavalue from dual) aaa where aaa.key1 = keytable.key1 and aaa.key2 = keytable.key2) aaavalue ,(select bbb.aaavalue from (select …