pcsoft.us.windevCopyright 2026, PC SOFT22 Aug 2015 01:31:00 Z16 Aug 2015 23:57:00 ZHello guess it's an easy Problem but since my mysql knowledge is Zero I have no clue. I Need a mysql Statement which Looks at the Moment like this and it doesn't work (created by WD): SELECT Ausstellung.VernissageDatum AS VernissageDatum, Ausstellung.Titel AS Titel, Ausstellung.FlyeriD AS FlyeriD, Ausstellung.AusstellungID AS AussstellungID, Kuenstler.Name AS Name, Kuenstler.Vorname AS Vorname, AusstellungKuenstler.AusstellungKuenstlerID AS AusstellungKuenstlerID, AusstellungKuenstler.Objekte AS Objekte FROM AusstellungKuenstler RIGHT OUTER JOIN Ausstellung ON Ausstellung.AusstellungID = AusstellungKuenstler.AusstellungID, AusstellungKuenstler INNER JOIN Kuenstler ON Kuenstler.KuenstlerID = AusstellungKuenstler.KuenstlerID ORDER BY VernissageDatum DESC I have three tables: Ausstellung=Exhibition Kuenstler=Artist AusstellungKuenstler=ExhibitionArtist (supporttable since an Exhibition can have several artists and an Artist can have several exhibitions. All I want is a record for all AUSSTELLUNG whether there is an AUSSTELLUNGKUENSTLER or not and if there is one I Need Name and title from KUENSTLER Any help is appreciated. Thx in advance Stephan30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53627/read.awp22 Aug 2015 01:31:00 ZHI CCC2 Thanks for posting that article. I'll keep an eye on the views I'm using with MySQL - which is a lot. However I alway…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53627/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53627/read.awpWD and mySQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53624/read.awp21 Aug 2015 23:53:00 ZHi SwissStephan, from your first post, you indicated needing a MySQL statement, so I assumed yo are using MySQL server. rega…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53624/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53624/read.awpWD and mySQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53610/read.awp21 Aug 2015 06:27:00 Zthis is my recommendation of database server . a) if working with big project (over 50 tables and storage above 2gb ) and com…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53610/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53610/read.awpWD and mySQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53609/read.awp21 Aug 2015 05:48:00 Zfor view , read this old blog. also mention in book about mysql perfromance https://www.percona.com/blog/2007/08/12/mysql-view-…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53609/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53609/read.awpWD and mySQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53608/read.awp21 Aug 2015 01:38:00 ZI use MySQL a lot - find it much faster and more robust that HFSQL. I'm interested in your comment that views are actually ta…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53608/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53608/read.awpWD and mySQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53607/read.awp21 Aug 2015 01:19:00 ZHi Stephen, H?F SQL is a junk . it is ok for small and simple db. if your db consist over 50+ tables with over 30GB then you …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53607/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53607/read.awpWD and mySQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53605/read.awp20 Aug 2015 23:01:00 ZHi Ned, hi Issah Thanks for your answers. I tried Ned's Version and it seems, it gives the desired result. Issah, if possible …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53605/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53605/read.awpWD and mySQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53589/read.awp20 Aug 2015 01:40:00 ZHi Swissstephan, whenever I have more than two tables being used in a query...especially with outer joins, I find it better t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53589/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53589/read.awpWD and mySQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53557/read.awp17 Aug 2015 16:09:00 ZHi Stephan, You could try something like... SELECT Ausstellung.VernissageDatum AS VernissageDatum, Ausstellung.Titel AS Ti…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53557/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53548-and-mysql-53557/read.awpWD and mySQL