What's the reason of Table1 ?


----- Original Message -----
From: "Dhaval Gandhi " <oracledba-ezmlmshield-x32592380.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Subject: How to fetch record ?
Date: Thu, 5 Jan 2006 16:35:48 +0530

>
> 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,
>
>
>
>
>
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html



DEGAND XAVIER

DX SPRL

BRUSSELS, BELGIUM


Oracle LazyDBA home page