Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Use SQL querie with joins in UI datatable
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Use SQL querie with joins in UI datatable
#32346
Use SQL querie with joins in UI datatable 11 Years, 6 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)
The administrator has disabled public write access.
 
#32347
Re:Use SQL querie with joins in UI datatable 11 Years, 6 Months ago Karma: 746
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
The administrator has disabled public write access.
 
Go to topPage: 1