Select Formno, Memname, State, Product, Total
From (Practice1 as a inner join Statemaster as b on a.code=b.code)
inner join Sales as c on a.formno=c.formno
Where b.activestatus='Y'
order by State, Formno
Error:-
Server: Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'Formno'.
Server: Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'State'.