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.
> There is no example in the MySQL docu for this. Only for two tables.
> The way i tried it was from MS Access. The only other database i am using is
> Oracle. And Oracle has a completely different join syntax.
[...]
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
