Results 1 to 2 of 2

Thread: Help SQL Statement Joining Tables?

  1. #1

    Thread Starter
    Lively Member networkmancer's Avatar
    Join Date
    Jan 2011
    Posts
    98

    Help SQL Statement Joining Tables?

    The problem is that it will show 2 the same result but with different employee fname.
    How to have something like this .
    "Employee.employee_id has employee.fname "



    Code:
        Select Distinct TRANSACTION.TRANSACTION_ID ,CUSTOMER.FNAME ,CUSTOMER.LNAME,PET.PNAME,Employee.Emp_ID,Employee.fname,TRANSACTION.DATESTART,TRANSACTION.DATEEND
        from(TRANSACTION)
         
        INNER JOIN CUSTOMER
        ON TRANSACTION.CUSTOM_ID = CUSTOMER.CUSTOM_ID
        INNER JOIN PET
        ON TRANSACTION.PET_ID = PET.PET_ID
        INNER JOIN EMPLOYEE
        ON TRANSACTION.EMP_ID = EMPLOYEE.EMP_ID
        Where TRANSACTION.STATUS=1
        order by TRANSACTION.TRANSACTION_ID
    TRANSACTION TABLE COLUMNS
    Code:
    TRANSACTION_ID CAMOUNT COST CHANGE CUSTOM_ID EMP_ID PET_ID DATESTART DATEEND SERVICES STATUS ROOMCOST DATETODAY
    EMPLOYEE TABLE COLUMNS
    Code:
        EMP_ID FNAME MNAME LNAME AGE ADDRESS BDAY EMPTYPE USER_ID
    PET TABLE COLUMNS

    Code:
        PET_ID PNAME PCOLOR PBREED PGENDER PET_ID PNAME PCOLOR PBREED PGENDER

    CUSTOMER TABLE COLUMNS

    Code:
    
        CUSTOM_ID FNAME MNAME LNAME ADDRESS CONTACT_NUM EMAIL EMP_ID PET_ID
    Requiscat En Pace

  2. #2
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,205

    Re: Help SQL Statement Joining Tables?

    Do you have duplicate Emp_ID in the Employee table? Do you have the same Employee with different first names and different emp_id?

Posting Permissions

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



Click Here to Expand Forum to Full Width