I have a SQL Table it have five main field f_no,f_capital,f_interest,f_vat and f_duedate.
I use below query
(1).Select f_capital,f_interest from FORCAST_02 where
(DATEPART(month, FORCAST_02.F_DUEDATE) = DATEPART(month, GETDATE())) AND (DATEPART(year, FORCAST_02.F_DUEDATE) = DATEPART(year,GETDATE())) and f_no='LC001'
now i want to get a f_vat sum in this table with above query.
(2).Select f_no,sum(f_vat) from FORCAST_02 where f_no='LC001' and FORCAST_02.F_DUEDATE<=getdate()
manually properly work this query, but i want to combined that two query,
PLEASE HELP ME....