Hi.
On Tue, Oct 02, 2001 at 07:25:38AM +0200, [EMAIL PROTECTED] wrote:
[...]
> first thanks for your answer.
> Your example does not work because the IdentNrS field is not in the table
> Bestellungen_Status.
Sorry, but there is no such table "Bestellungen_Status"? You mean
Bestellungen_Status_Text?
> I have to link BestellungenAdr,Bestellungen_Status_Text,BestellungenP to
the
> table Bestellungen.
Oops, sorry. Did overlook that.
FROM BestellungenAdr e
INNER JOIN Bestellungen a USING(IdentNrS)
LEFT JOIN Bestellungen_Status_Text f USING (BestellStatus)
INNER JOIN BestellungenP b ON b.IdentNrS = a.IdentNrS
INNER JOIN artikel c USING (IdentNrA)
INNER JOIN ArtikelText d USING (IdentNrA)
Is that correct now? If not, you surely got the idea.
Bye,
Benjamin.
Hello,
yes it works fine. I have worked the last few years with Oracle and i am new
to the join syntax.
Thanks again.
Armin
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
