can please help me towrite better than this query

  • can please help me to write better than this query but i want same output ...

    select a. emp_id,a.uid,a.LAST_NAME,a.FIRST_NAME,a.MIDDLE_INIT,a.L_ID ,a.MANAGER_ID,b.l_id,b.loc_desc,c.office_phone,c.home_phone,c.cell_phone from employee a, emp_location b ,emp_contact c where a.emp_id =c.emp_id and a.l_id =b.l_id

  • Please don't cross post into multiple forums. Most of the people answering questions here read across many of the forums. Cross posting just leads to confusion as different people answer the question at different times and don't see the other responses until later.

    All responses to this question should go here.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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