i tried to get multi select from two column i used the code but in vain [on hold]

85
February 07, 2018, at 3:33 PM
SELECT 
 Month_ID,Year_ID,
  (SELECT Vas_Name FROM Main_Report  WHERE Duration_Period = 'same day' ) AS price,
  (SELECT Vas_Name FROM Main_Report WHERE Duration_Period = 'next Day') AS taste
FROM Main_Report

Msg 512, Level 16, State 1, Line 1

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

READ ALSO
Unable to restart Hadoop daemons after quit from hive

Unable to restart Hadoop daemons after quit from hive

I have installed Hadoop and Hive with MySQL metastoreI started Hadoop daemons then I started Hive shell

141
How can I place select and insert code in the same PHP file while using AJAX?

How can I place select and insert code in the same PHP file while using AJAX?

I am new to Ajax and JqueryHaving learnt the fundamental concepts, I tried to make a PHP application wherein values could be inserted and shown right below it with a click of a button using Ajax, PHP and Jquery

103
Trigger updating value before insert by multicating two columns

Trigger updating value before insert by multicating two columns

I have to modify value of an inserted data with a trigger beforeHere is my trigger :

58