Regarding: where nothing is said about not supporting "RIGHT"
UhRIGHT. Apparently, right is wrong. ;-)
Though it may be corrected just by virtue of being posted on this list,
anyone can submit a ticket on the documentation (or edit the wiki
portion directly).
thanks Igor,
Q2:
Why isn't ALIAS supported in the JOIN-line, or am I doing something
wrong ?
SELECT Patient_text.*, Opnamen.*
FROM Patient
INNER JOIN Patient_text, Opnamen AS O
WHERE Patient.PatNr = Patient_text.PatNr
ANDPatient.PatNr = '1'
What exactly
Stef Mientki <[EMAIL PROTECTED]> wrote:
Q1:
What's the difference between ON and WHERE,
the 2 statements below return exactly the same ?
SELECT Patient_text.*, Opnamen.*
FROM Patient as P
INNER JOIN Patient_text, Opnamen
ON P.PatNr = Patient_text.PatNr
WHERE P.PatNr
3 matches
Mail list logo