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 ? <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) > >
I think the problem may be that you have given Opnamen as alias, yet still use the full table name in the SELECT line. I believe you need to change it to SELECT Patient_Text.*, O.* etc. David ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------