GROUP BY not returning what I expect.

2001-11-27 Thread TD - Sales International Holland B.V.
First of all please CC me since I'm no longer a member. I had to unsubscribe since I receive too much already... Sorry about that. I think this is just me and my not so good understanding of the GROUP BY function. What happens is that it returns less lines than I expect it too. Perhaps it has

UNION/INTERSECT

2001-11-23 Thread TD - Sales International Holland B.V.
Hey there, first of all please CC my email address as I'm no longer a member of this list. Recieving too much stuff already (1000+ mails a day) Anyways I found a general SQL manual which uses oracle to show it's demos. So I tried some of the examples in there some work but don't do the expecte

more commands that don't work (yet)

2001-11-23 Thread TD - Sales International Holland B.V.
please CC [EMAIL PROTECTED] as i'm not a member in addition to my earlier email this doesn't work either regards INPUT: SQL> SELECT * FROM SOFTBALL 2 MINUS 3 SELECT * FROM FOOTBALL; OUTPUT: NAME BAKER DEAN FALCONER ---

Problem listing enum vars

2001-10-18 Thread TD - Sales International Holland B.V.
Hey there, first off all, please CC me any replies, as I'm no longer a member of the list... Sorry about that but I just receive too much... Over 2000 emails a day is no exception and I can no longer keep track of them. Ok, for the problem, I want to list the possible values of a enum variable