Re: OUTER JOIN format generated by VFP (over ODBC) - Sasha Pachev - com.mysql.lists.bugs

2 messages in com.mysql.lists.bugsRe: OUTER JOIN format generated by VF...

From	Sent On	Attachments
Horský Vladimír	28 Jul 2001 12:51
Sasha Pachev	28 Jul 2001 16:28

Subject:	Re: OUTER JOIN format generated by VFP (over ODBC)
From:	Sasha Pachev (sas...@mysql.com)
Date:	07/28/2001 04:28:09 PM
List:	com.mysql.lists.bugs

On Saturday 28 July 2001 13:52, Horsk? Vladim?r wrote:

Hi. Trying to use Remote View Designer in Visual FoxPro (version 6 in my case) to automatically create view with more tables joined with OUTER JOIN generates this type of query that is not syntactically supported by MySQL:

SELECT Etapy.ID_etapy; FROM {oj etapy Etapy LEFT OUTER JOIN vazba_ubytovani Vazba_ubytovani; LEFT OUTER JOIN cenik Cenik; LEFT OUTER JOIN pokoje Pokoje; LEFT OUTER JOIN hotely Hotely; LEFT OUTER JOIN varianty Varianty; LEFT OUTER JOIN varianty Varianty_a ; ON Vazba_ubytovani.ID_ubytovani = Varianty_a.ID_ubytovani ; ON Vazba_ubytovani.ID_ubytovani = Varianty.ID_ubytovani ; ON Pokoje.ID_hotel = Hotely.ID_hotel ; ON Cenik.ID_pokoje = Pokoje.ID_pokoje ; ON Vazba_ubytovani.ID_cenik = Cenik.ID_cenik ; ON Etapy.ID_etapy = Vazba_ubytovani.ID_etapy }

I do not know if this is correct syntax by ODBC definition, but this is fact that this does not work.

We need more details on the "it does not work part". What exactly does not work? What error message are you getting?

The protocol in posting to bu...@lists.mysql.com is that you create have to create a full test case so the developer troubleshooting the problem will be able to repeat the bug.