On Wed, Feb 14, 2007 at 17:21:44 -0500,
"Edward W. Rouse" <[EMAIL PROTECTED]> wrote:
>
> I tried using coalesce(count(value4)) and case count(value4) = 0
> with no luck. I tried left and right joins and the right join gave me
> the same results while the left join gave me rows like:
That is b
I have 2 tables that look like this:
table1 table2
-
value1 | value2 value1 | value3 | value4
-
one| a one| a | jim
one| b one| d | bob
one| c
On 11/15/06, Luca Ferrari <[EMAIL PROTECTED]> wrote:
On Wednesday 15 November 2006 16:20 your cat, walking on the keyboard,
wrote:
> May be you could show the results you are getting and then make up some
> results that you would really like to get. I am not entirely clear what
> you are trying
On Wednesday 15 November 2006 16:20 your cat, walking on the keyboard, wrote:
> May be you could show the results you are getting and then make up some
> results that you would really like to get. I am not entirely clear what
> you are trying to achieve.
Lastly I found the solution, for the mome
> Hi all,
> I've got a problem tryng to define a view with a few joins, I'll appreciate
> if
> someone could drive me in the definition of such query.
> I've got a table roleSkill that contains a row for each skill belonging to a
> defined role and with the desired competence level for such ski
Hi all,
I've got a problem tryng to define a view with a few joins, I'll appreciate if
someone could drive me in the definition of such query.
I've got a table roleSkill that contains a row for each skill belonging to a
defined role and with the desired competence level for such skill in such
r
