Syntax errors. Try:
SELECT studenti.*
FROM studenti LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid
WHERE ISNULL( valutazioni.sid )
Ignatius
- Original Message -
From: "Francesco" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROT
It would be nice to have the possibility to exclude CREATE TEMPORARY TABLE
statements from the log bin.
Because such statements are really used not for updating a DB, but for
constructing intermediary statements that eventually derive in a final
INSERT/ UPDATE. I believe only this final statement
In addition I would suggest to verify that your text file does not end with
a CR or LF character. This happens very often on Windows systems when for
instance saving an Excel sheet as a text file.
If you do not remove this last character(s), you risk inserting a blank row
in the DB.
Ignatius
Quotes missing around dates.
WHERE "2003-03-14" ...
Ignatius
- Original Message -
From: "Cory Hicks" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 9:05 PM
Subject: Finding an ID between two dates
> Hey folks!
>
> I a
