How do i query these lines in one single line someone help please??

[Ronel]

SELECT `itemname`,`poqty` FROM `history` WHERE action = 'Added qty'
SELECT `received_qty` FROM `history` WHERE action = 'Stock Received'
SELECT `outgoing_qty` FROM `history` WHERE action = 'Outgoing Record Recorded'

How do i query these lines in one single line someone help please??

Below is my image for database history.

[requinix]

Have you tried a query that lists all the columns and requires any of the conditions?

[ginerjm]

What requinix is possibly saying is to use a WHERE clause that includes all of your 'ifs' in one query statement.  You may want to use an ORDER BY clause at the same time.   Suh as:  Where fld='xxx' or fld == 'yyy' or fld  ='zzz' order by fld

 

[Ronel]

yes below image is what i got after running the query in my database. But how do put the itemname row on same line ? it has several entries with same itemnames?

[Phi11W]

13 minutes ago, Ronel said:

it has several entries with same itemnames?

Well, yes it does, because that's what's in your data! 

What you're missing is the action that caused each row to appear in your results.  Include the action column and your data should make a little more sense. 

What are you trying to achieve?  Calculation of total stock levels based on actions against each item? 

For that you'd want something like this: 

select 
  id
, sum( 
  case action
  when 'Added Qty' 
  then poqty
  when 'Stock Received' 
  then received_qty
  when 'Outgoing Record Recorded' 
  then - outgoing_qty 		/* negate value to deduct from total */
  end 
  ) qty 
from table1 
group by id 
order by action ; 

Bear in mind that ordering by a text field (whose values might change over time) could give you headaches. 
It might be better to codify these values (into a "Lookup" Table) so that you can sequence them reliably.  

Regards, 
   Phill  W.