It's not clear what you are trying to do with the "Column"
(Select SUM(stk_i.ItemIn) As 'In_', SUM(stk_i.ItemOut) As 'Out_' From tbl_Stock stk_i),
If you are trying to return two values from that sub-query then you can't.
If you want both values as columns then you have to separate them out
(Select SUM(stk_i.ItemIn) As 'In_' From tbl_Stock), (Select SUM(stk_i.ItemOut) As 'Out_' From tbl_Stock stk_i),
But that really is an awful way to do it.
It looks like those totals are supposed to be by tbl_Stock.RecordItem in which case it should just be
SUM(stk_o.ItemIn), SUM(stk_o.ItemOut),
Or you could have a sub-query as another join.
If this doesn't help then use the
Improve question link to add some sample data from each of the tables and your expected result (for the sample data). If you then reply to this solution I will be notified of the change and I will have another look