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
D
dadasay2019-08-27 16:59:03
Can I throw an exception from thread A on thread B? 2Reply
A
Anholle2019-09-09 11:37:42
How to set up a filter in the feedback form? 0Reply
N
NyxDeveloper2021-05-04 16:15:55
How to forbid assigning id to fields of ForignKey of that object, whose certain field is equal to False? 4Reply
K
Kordamon2019-11-07 18:48:19
Dropbox: how to unsync for a subfolder? 3Reply
D
dfhkjhg2020-11-24 11:57:49
How to add multiple id's to a user from another table? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question