SQL code Help Urgent

[maduprasad]

Machanla,

assignment ekakata sql codes wagayak dana ganna ona.
please mata ikmanata udaw karanna.

 

[tigooo]

udau karunna prashne keyapanko,

 

[THE SKULL]

ado matath one bn sql help ekak ...

 

[maduprasad]

udau karunna prashne keyapanko,

Member Table
Volunteer Table
Skill Table

List All volunteers in a specific given Skill

 

[badangel]

Member Table
Volunteer Table
Skill Table

List All volunteers in a specific given Skill

Oya kiyana problem 1ka hariyata therune naha.hariyata dammoth nam help 1kak denna puluwan

 

[duka]

machan Table structure eka dapan hariyatama kiyanna.
I guess Like this

SELECT * FROM MEMBER as m
INNER JOIN Volunteer as v ON m.MemberID=v.MemberID
INNER JOIN Skill as s ON m.SkillID=s.SkillID
WHERE s.Skill='Specific Skill Name'

 

[thilina91]

bamp

 

[tigooo]

SELECT *
FROM Volunteer,Skill
WHERE Skill=XXXXX

ube retails teka anuwanam oka thamai denna puluwan answer1

Dukage 1 wage join danna one wenne ne, WHERE 1 de foreign key teka dunnanam

 

[maduprasad]

Volunteer's Skill - idSkill, Physicians, Engineers, Lecturers
Member Table - idMember, name, address, phone
Volunteer - idVolunteer, idMember, Service, hourly Rate

machan mama volunteer ge normal details tika member ta dunna (Relation)

 

[chint]

bump

machanla SQL walin wada karanna thamangee computer eke install karanna hoda mokakda?
mysql,microsoft sql server etc....

 

[badangel]

select *
from Volunteer T , Skill S
where t.xx = S.xx
And S.Skill = 'xxx'


t.xx = s.xx
[vounteer table and Skill table should have relation and
you have to put your relation here]

S.skill = 'Put your skill name here'

Hope this will help you.

 

[duka]

Ko meke Memberta skill link karala nane.

 

[badangel]

machanla SQL walin wada karanna thamangee computer eke install karanna hoda mokakda?
mysql,microsoft sql server etc....

machan uba SQL igana ganna nam MSSQL use karanna,mokada eke wada karanna hari lasi. oya visual studio wala wada karanawa nam MSSQL godak hodai. Java wage program language ekak use karanawa nam MYSQL thama hoda.

 

[hansa1018]

බම්ප්

 

[maduprasad]

Ko meke Memberta skill link karala nane.

Machan Please mata wenna ona widihi kiyapan

 

[badangel]

oya menna mehama table tika hada ganna

SKILL - skillId , volunteerID, skilltype
Memeber - memberID,name, address, phone
Volunteer - volunteerID , memberId , service ,hourlyrate

eta passe oyata query 1kam mehema liyanna puluwan and skilltype kiyana ekata



select *
from Skill S, Volunteer V
where S.volunteerid = V.idVolunteer
and S.skilltype = 'Engineer'

etakota enginnersla wena okkaoma volunteerslawa hoyaganna puluwan.

 

[maduprasad]

Machan ethakota mata
Volunteer through Member details tikath pennana ona.

If it is ok mata assignment eka mail ekak danna puluwan
ada dead line ban ekai

 

[maduprasad]

1. A “Donator”, refers to a person who donates money or equivalent items (e.g.
gold, shares, properties, etc).
2. A “Volunteer” refers to unpaid helper who voluntary provide his/her service
free of charge (e.g. professional people such as Physicians, Engineers,
Lecturers, etc.) or assist in certain activities.
3. A “Contributor” refers to a person who can be a Donator, Volunteer or both.

A1. List all Volunteers who are willing to contribute in a specific given activity.
Produce the SQL code only (i.e. no form or report).

 

[twisted]

Member Table
Volunteer Table
Skill Table

List All volunteers in a specific given Skill

your questions very vague, but I'll try

select * from volunteer_table
where skill_id in (select skill_id from skill_table
where skill_name = 'your given skill')

this is assuming, skill id is referred against each volunteer.

 

[badangel]

select m.memberid,m.name, m.address, m.phone
from Memeber m , volunteer V, skill S
where S.volunteerid = V.VolunteerID
and M.memberid = V.memberid
and s.skilltype = 'Enginner'


mahan meka hariyanawada balapan.mamath me exam ekakata padam karana gaman.