thanks Igor,
Q2:
Why isn't ALIAS supported in the JOIN-line, or am I doing something
wrong ? <SQL>
SELECT Patient_text.*, Opnamen.*
FROM Patient
INNER JOIN Patient_text, Opnamen AS O
WHERE Patient.PatNr = Patient_text.PatNr
AND Patient.PatNr = '00001'
</SQL>
What exactly do you believe is not supported? Do you get an error with
this statement? It looks good to me.
I get the following error ":: no such table: Opnamen" (running from Delphi)
Q3:
In the SQL help on the web, I read:
"/join-op/ ::= *, *|* *[*NATURAL*]* *[*LEFT *|* RIGHT *|* FULL*]*
*[*OUTER *|* INNER *|* CROSS*]* JOIN*"
But when I try a RIGHT JOIN, I get an error message ???
SQLite doesn't support right outer joins at this time, only left
joins. By the way, SQL syntax supported by SQLite is documented here
http://www.sqlite.org/lang.html
Yes, and the above quote is from
http://www.sqlite.org/lang_select.html
where nothing is said about not supporting "RIGHT",
and now I assume this page lists a lot more that's not supported (yet) ;-)
--
cheers,
Stef Mientki
http://pic.flappie.nl
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
