こんなSQL書いてみた

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 '2008-6-27' key1
			,11111 key2
			,106 aaavalue
		  from dual) bbb
	 where bbb.key1 = keytable.key1
	   and bbb.key2 = keytable.key2) bbbvalue
	,(select ccc.aaavalue
	  from (select '2008-6-27' key1
			,11111 key2
			,107 aaavalue
		  from dual) ccc
	 where ccc.key1 = keytable.key1
	   and ccc.key2 = keytable.key2) cccvalue
	,(select ddd.aaavalue
	  from (select '2008-6-27' key1
			,11111 key2
			,108 aaavalue
		  from dual) ddd
	 where ddd.key1 = keytable.key1
	   and ddd.key2 = keytable.key2) dddvalue
	,(select eee.aaavalue
	  from (select '2008-6-27' key1
			,11111 key2
			,109 aaavalue
		  from dual) eee
	 where eee.key1 = keytable.key1
	   and eee.key2 = keytable.key2) eeevalue
  from (select '2008-6-27' key1
		,11111 key2
	  from dual) keytable

◆結果

KEY1 KEY2 AAAVALUE BBBVALUE CCCVALUE DDDVALUE EEEVALUE
2008-6-27 11111 105 106 107 108 109