Results 1 to 2 of 2

Thread: qurey error

  1. #1
    Join Date
    Mar 2003
    Location
    Stoke on Trent
    Posts
    8

    Unanswered: qurey error

    Hello there

    I am not able to run this qurey, some one help me please

    select initcap(title),
    initcap(surname),
    initcap(forename),
    initcap(gender),
    tel_No,
    Mobile,
    Pager,
    email,
    day_of_week,
    am_flag,
    language,
    experience_type,
    qualification_type
    from interpreter,
    availability,
    language,
    int_lang,
    int_avail,
    experience,
    int_exp,
    qualification,
    int_qual
    where
    interpreter.int_id = int_lang.int_lang_id
    and int_lang.int_lang_id = language.l_id
    and interpreter.int_id = int_avail.int_avail_id
    and int_avail.int_avail_id = availability.a_id
    and interpreter.int_id = int_exp_id
    and int_exp_id = experience.e_id
    and interpreter.int_id = int_qual.int_quaL_id
    and int_qual.int_quaL_id = qualification.q_id
    and gender = 'F'
    and Day_of_week ='MON'
    and am_flag ='Y'
    and language.language like 'Urdu'

  2. #2
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208

    Re: qurey error

    Do you get an error message, or no rows returned?

    If no rows are being returned, check that the IDs in your tables are matching up.

    Originally posted by nahmed
    Hello there

    I am not able to run this qurey, some one help me please

    select initcap(title),
    initcap(surname),
    initcap(forename),
    initcap(gender),
    tel_No,
    Mobile,
    Pager,
    email,
    day_of_week,
    am_flag,
    language,
    experience_type,
    qualification_type
    from interpreter,
    availability,
    language,
    int_lang,
    int_avail,
    experience,
    int_exp,
    qualification,
    int_qual
    where
    interpreter.int_id = int_lang.int_lang_id
    and int_lang.int_lang_id = language.l_id
    and interpreter.int_id = int_avail.int_avail_id
    and int_avail.int_avail_id = availability.a_id
    and interpreter.int_id = int_exp_id
    and int_exp_id = experience.e_id
    and interpreter.int_id = int_qual.int_quaL_id
    and int_qual.int_quaL_id = qualification.q_id
    and gender = 'F'
    and Day_of_week ='MON'
    and am_flag ='Y'
    and language.language like 'Urdu'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •