Query needed

• • Reply

  14 years ago

  by vamsy

  vamsi choudary

  Hyderabad, India

  Joined 14 years ago

  I am very new to this

  i need a query to retrive the Employees Names and their manager name(based on mgr number)

  Report abuse
• • Reply

  14 years ago

  by sync_or_swim

  Rob Bickel

  S. Wales, United Kingdom

  Joined 15 years ago

  The following query is based upon two tables as follows:
  
  tblEmployees:
  emp_num                   Integer         Key
  emp_first_name         VarChar2(20)
  emp_surname            VarChar2(25)
  man_num                   Integer         Foreign Key
  
  tblManagers:
  man_num                   Integer         Key
  man_first_name          VarChar2(20)
  man_surname             VarChar2(25)
  
  SELECT tblEmployees.emp_first_name, tblEmployees.emp_surname, tblManagers.man_first_name, tblManagers.man_surname
  FROM tblEmployees, tblManagers
  WHERE tblEmployees.man_num = tblManagers.man_num
  AND tblEmployees.man_num = 1
  
  This will return all employees of manager number 1
  
  Without meaning to sound rude, when posting a problem like this it is helpful to give a thorough description of your tables and exactly what it is that you are trying to achieve, you will get a more detailed response!!!
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

  Report abuse
• • Reply

  14 years ago

  by vamsy

  vamsi choudary

  Hyderabad, India

  Joined 14 years ago
  thanku for your reply and  i need the query for "emp" table in the sql. for single table only
  Report abuse
• • Reply

  14 years ago

  by sync_or_swim

  Rob Bickel

  S. Wales, United Kingdom

  Joined 15 years ago

  vamsy wrote:

  i need the query for "emp" table in the sql. for single table only

  
  
  ????????????
  
  How are we supposed to help you construct a query if you don't give a detailed explanation of the fields that your table contains, their datatypes and the fields you want to extract with the query?
  
  
  
  
  Report abuse