Millions of thanks!
Now it's working perfectly!!!
Once again MS bugs...
Regards
Juha
-Alkuperäinen viesti-
Lähettäjä: Terence [mailto:terencel@;sunway.edu.my]
Lähetetty: 23. lokakuuta 2002 4:54
Vastaanottaja: Morsky Juha; [EMAIL PROTECTED]
Aihe: Re: Strange problem with MySql
Hi All!
I've Select like this:
SELECT ExpDepDate, ActArrDate FROM oceandata
It works beautifully
But When I modify it like this
SELECT ExpDepDate, ActArrDate, Count(Ref) as NoOfRefs FROM oceandata
I'll get nothing, just a empty screen with a browser!
I'm using Ultradev to create this and whe
Hi All!
I've Select like this:
SELECT ExpDepDate, ActArrDate FROM oceandata
It works beautifully
But When I modify it like this
SELECT ExpDepDate, ActArrDate, (TO_DAYS(ActArrDate)-TO_DAYS(ExpDepDate)) as
Act_Est FROM oceandata
I'll get nothing, just a empty screen with a browser!
I'm using U
Do anyone has a idea how to Insert (create SQLQuery) from onetable to an
other table as
decripted under:
Here is the orginal Table:
Table1:
Ref | Timestamp | ActionDate
---+-+
001 | DEP + 2002/01/02