Duplicate entry \'8333026\' for key \'jos_fb_whoisonline.PRIMARY\' SQL=INSERT INTO jos_fb_whoisonline (`userid` , `time`, `what`, `task`, `do`, `func`,`link`, `userip`, `user`) \n VALUES (\'0\', \'1714261014\', \'Use SQL querie with joins in UI datatable\',\'\',\'\',\'view\',\'https://www.ari-soft.com/index.php?option=com_kunena&Itemid=54&catid=28&func=view&id=32346&lang=en\', \'3.15.174.76\', \'0\')
Use SQL querie with joins in UI datatable
(0 viewing)
| | |
TOPIC: Use SQL querie with joins in UI datatable
|
Use SQL querie with joins in UI datatable 11 Years, 7 Months ago
|
Karma: 0
|
Hi,
I tried several things to get my query in an ui data table, but no luck. A simple query i get to work but not with joins. How can I do this?
This is my query:
SELECT er_klant_algemeen.ER_Klant_algemeen_Nr,
contractrekening.Contractrekening_Nr,
verbruiksplaats.VP_Nr,
verbruiksplaats.VP_Adres,
verbruiksplaats.VP_Adres_Nr,
verbruiksplaats.VP_Adres_Toev,
leveringsinstallatie.Eancode,
leveringsinstallatie.Inst_Prod
FROM ( ( verbruiksplaats verbruiksplaats
INNER JOIN
leveringsinstallatie leveringsinstallatie
ON (verbruiksplaats.VP_Nr = leveringsinstallatie.Inst_Nr_VP_Nr))
INNER JOIN
contractrekening contractrekening
ON (contractrekening.Contractrekening_Nr =
verbruiksplaats.VP_Contractrekening_Nr))
INNER JOIN
er_klant_algemeen er_klant_algemeen
ON (er_klant_algemeen.ER_Klant_algemeen_Nr =
contractrekening.ER_Klant_algemeen_Nr)
|
|
|
|
|
Re:Use SQL querie with joins in UI datatable 11 Years, 7 Months ago
|
Karma: 748
|
Hello,
Could you send SQL dump with sample data of tables which are used in query by email and specify what plugin code do you use?
Regards,
ARI Soft
|
|
|
|
|
|
| | |