I have two tables like :

Table 1

No Code
00001 001
00002 003
00003 004

Table 2

No Remark
00001 This
00001 is
00001 Sample
00002 I
00002 Think
00002 it is
00002 Difficult


I want to write a query which gives me following output.

No Remark
00001 This is Sample
00002 I Think it is Difficult


How can I generate output like this ?


Regards,








Oracle LazyDBA home page