Retrieve data from Three table using JOIN

[Yogesh Sharma]

create table stuinfo(roll int,name varchar(10))
insert into stuinfo values(1,'sonia ')
insert into stuinfo values(2,'usha' )
select * from stuinfo

create table marks(roll int,grade varchar)
insert into marks values(1,'A')
insert into marks values(2,'B')
select * from marks

create table fees(roll int,totfess int,remfess int)
insert into fees values(1,5000,1 000)
insert into fees values(3,5000,0 )
select * from fees

select stuinfo.roll,na me,grade,tofees
from stuinfo
JOIN marks On stuinfo.roll=ma rks.roll
JOIN fees on marks.roll=fees .roll
error-Invalid Column totfees

[ck9663]

create table stuinfo(roll int,name varchar(10))
insert into stuinfo values(1,'sonia ')
insert into stuinfo values(2,'usha' )
select * from stuinfo

create table marks(roll int,grade varchar)
insert into marks values(1,'A')
insert into marks values(2,'B')
select * from marks

create table fees(roll int,totfess int,remfess int)
insert into fees values(1,5000,1 000)
insert into fees values(3,5000,0 )
select * from fees

select stuinfo.roll,na me,grade,tofees
from stuinfo
JOIN marks On stuinfo.roll=ma rks.roll
JOIN fees on marks.roll=fees .roll
error-Invalid Column totfees

Your create table says

create table fees(roll int,totfess int,remfess int)

Your query says
select stuinfo.roll,na me,grade,tofees

-- CK

[Yogesh Sharma]

Thx Yaar. Sory, Its by mistake tofees.

[ck9663]

So do you still have that error?

-- CK

[Yogesh Sharma]

No yaar, its working