SQL code Help Urgent

badangel

Member
Aug 2, 2009
19
1
0
Colombo
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).


macho ubata full question 1kama danna barida???? tikak balala answers denna amarui macho.
 

maduprasad

Active member
  • Sep 13, 2006
    926
    149
    43
    mahan meka hariyanawada balapan.mamath me exam ekakata padam karana gaman. :D

    Thanks Machan Wade Goda

    Mata machan meka dena ganna ona

    mama access database Haduwe
    mata ona member kenek hadaddi eya mona type da (Volunteer / Donator / Administrator., Etc select karaganna.
    mata passe balaganna ona Volunteersla wenama Donators la wenama

    time eka thiyenawanam poddak help machan
     

    rehrumesh

    Member
    Jun 17, 2008
    594
    56
    0
    macho ubata full question 1kama danna barida???? tikak balala answers denna amarui macho.


    Sirawatama.prashne sampoornayen thibbanam wade leesi. mokada wena un wage nathuwa umba kelinma kiyala thiyanawane assignment ekata kiyala.so directly question ekama daapan....:yes::yes::yes::yes:
     

    CM_LK

    Active member
  • Oct 3, 2010
    714
    80
    28
    MY SQL valata thiyana thana dan adu wegana enawa, eth dakama purudu wena eka thama hoda, vadiya wenasak nha , e wenasa tharum gathnam athi...
     

    Topology

    Member
    Feb 24, 2011
    2,395
    225
    0
    Out of Elakiri.
    Member Table
    Volunteer Table
    Skill Table

    List All volunteers in a specific given Skill


    5410542.png


    Code:
    SELECT 
    memberTable.memberName, 
    memberTable.vOrNot, 
    skillTable.skillName,
    FROM memberTable,skillTable FROM memberTable.vOrNot='volunteer' AND skillTable.skillName='skill Name' ORDER BY skillTable.skillName;
     

    maduprasad

    Active member
  • Sep 13, 2006
    926
    149
    43
    For all beneficiary institutes, list the contact name, phone numbers as well as all
    sponsoring organisations or caretakers of that institute (if any). Produce the
    SQL code only (i.e. no form or report).