Thanks a lot, The Query worked for me. Thanks for giving nice explanation
about ANSI Standard on SQL, which helped
me to understand standards across different RDMS.
On Fri, Oct 12, 2012 at 10:42 PM, Michael Bayer wrote:
>
> On Oct 12, 2012, at 9:40 AM, Praveen wrote:
>
> Hello,
>
> I have below u
On Oct 12, 2012, at 9:40 AM, Praveen wrote:
> Hello,
>
> I have below use where
>
> Employer and EmployerPhone the one emp can have multiple phone number out of
> which at any given point of time there should be
> only one 'is_active' due to concurrency load, emp_phone got multiple
> 'is_act
Hello,
I have below use where
Employer and EmployerPhone the one emp can have multiple phone number out
of which at any given point of time there should be
only one 'is_active' due to concurrency load, emp_phone got multiple
'is_active' as 'Y' in emp_phone i want to update the emp_phone table
