[sqlite] Re: Re: A few (probably) simple questions ...

2007-03-06 Thread Igor Tandetnik
Stef Mientki <[EMAIL PROTECTED]> wrote: 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 = '00

Re: [sqlite] Re: Re: A few (probably) simple questions ...

2007-03-06 Thread Stef Mientki
Igor Tandetnik wrote: Stef Mientki <[EMAIL PROTECTED]> wrote: 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 AND

Re: [sqlite] Re: Re: A few (probably) simple questions ...

2007-03-06 Thread David Bicking
On Wed, 2007-03-07 at 00:36 +0100, Stef Mientki wrote: > > Stef Mientki <[EMAIL PROTECTED]> wrote: > Q2: > Why isn't ALIAS supported in the JOIN-line, or am I doing something > wrong ? > SELECT Patient_text.*, Opnamen.* > FROM Patient > INNER JOIN Patien