Post reply

anyone can write a querry for this-

  • February 18, 2012 at 12:27 am

    #264760

    Hi, I have 3 tables project,timesheet and employee.

    I want a employee name if i have only the project name.

    details of tables-

    project table-projectid,projectname

    timesheet table-projectid,employeeid

    employee table-employeeid,employeename

    i am new in sql

    Please help me out.

    Thanks in Advance

  • February 18, 2012 at 1:06 am

    #1448875

    something along these lines will get you started.

    good luck with SQL 🙂

    SELECT Employees.EmployeeName,

    Projects.ProjectName

    FROM Projects

    INNER JOIN Timetable ON Projects.ProjectID = Timetable.projectID

    INNER JOIN Employees ON Timetable.employeeID = Employees.EmployeeID

    WHERE Projects.ProjectName = 'your project name'

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply