Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
D
D
denism3002016-07-27 12:48:17
SQL
denism300, 2016-07-27 12:48:17

How to remake a SQL query according to the JDatabaseHelper Joomla 3 constructor?

I have a query like:

SELECT IF ((SELECT SUM ('field_1) FROM ('table_1')) = (SELECT SUM ('field_2) FROM ('table_2')), 1, 0)

how to compose it according to JDatabaseHelper constructor?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)
Similar questions
I
Ivan Medvedev2020-03-04 08:06:16
How to make several page layout options depending on the value of a variable? 2Reply
M
mrWan2017-11-16 00:49:40
Phpexcel writes purely in exponential form. How can this be removed? 3Reply
D
Dmitry Chilikin2017-12-20 11:32:33
How to make an FTP proxy? 4Reply
B
BonBon Slick2017-07-07 19:59:49
Is it possible to somehow count the data of a column in a table? 1Reply
I
Ilya2019-12-06 10:59:00
How to transpose multiple columns into multiple rows? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question