Re: Suggestion with SQL query

[Donald Whittaker <donald_whittaker@xxxxxxxxx>]

   I believe you are _asking_ for one thing and
showing an _example_ of another.
   Going by the example, the first returned row shows
data from field 'value' in table T2.  The second shows
data from field 'value' in table T1 as there is no
matching row in table T2.  To do that, you could use
the COALESCE function:
   ...select id, type, COALESCE(T2.value, T1.value)...

Thanks,
Don

--- Ashish Kulkarni <kulkarni_ash1312@xxxxxxxxx>
wrote:

> Hi
> I need some suggestion with sql query
> I have 2 table
> T1 which has columns
> id, type, value
> And 
> T2 has columns
> id, type, value, user
>
> T1 has data as below
> id        Type     value
> schd      test     abc
> schd      test1    abc1
>
> T2 has data
> id        Type     value   user
> schd      test     xyz     myid
>
> I want to write a SQL to get data from T1 if there
> is
> no record in T2, The value in T2 may be different
> from
> T1.
>
> So my result after the query will be
> (i dont need user id)
> id        Type     value
> schd      test     xyz   (this comes from T2)
> schd      test1    abc1  (this comes from T1)
>
> Any suggestions
>
> Ashish 
>  
>
>
>
>
> A$HI$H
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam
> protection around 
> http://mail.yahoo.com 
> -- 
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.