Forum Replies Created

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

  • Reply To: Using a third table in small left outer join

    Sorry about that. I have the data ok but would like to know if it's possible to improve.

    select ac.full_name, ai.*, pev.program_name

    from all_clients_view ac left join

    alt_id_view ai

    on ac.people_id = ai.people_id left...

    • This reply was modified 1 year, 5 months ago by  pk400i.
  • Reply To: Trying to see all records

    So this should be fine? select a.*, b.full_name from alt_id_view a

    left outer join all_clients_view b

    on a.people_id = b.people_id

    It's only bringing in the matched so it could be the system we...

  • RE: Linked AS400 stopped working

    Is it possible a Userid or password has been disabled?

  • RE: Problem with my first SSRS report

    in the report check your report parameters, make sure that they are there and as you want them. It sounds like the dates are embedded there, make them nulls.

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