I've the next query, that we made to compile data from numerous sights according to client data.

SELECT 
  vw_clients.client_id, 
  name, 
  exts, 
  vms, 
  ivrs, 
  queues, 
  conf10, 
  conf20, 
  conf30
FROM 
  vw_clients, 
  vw_exts, 
  vw_vms, 
  vw_ivrs, 
  vw_queues, 
  vw_conf10, 
  vw_conf20, 
  vw_conf30
WHERE 
  vw_clients.client_id = vw_exts.client_id AND 
  vw_clients.client_id = vw_vms.client_id AND 
  vw_clients.client_id = vw_ivrs.client_id AND 
  vw_clients.client_id = vw_queues.client_id AND
  vw_clients.client_id = vw_conf10.client_id AND
  vw_clients.client_id = vw_conf20.client_id AND
  vw_clients.client_id = vw_conf30.client_id;

The query works fine as long as you will find records in each and every view relevant towards the records in volkswagen_clients. However I have to modify this to utilize a left join, to ensure that it returns all records from vm_clients and just individuals in the other sights which have records for individuals clients.

I have find out about left joins, but for the most part I've only found information on joining one or possibly two tables - but I have to join 8. Will I perform a left join on volkswagen_clients.client_id towards the corresponding client_id area in most from the sights? What is the syntax for your?

Would be thankful for any help. I am not far from fixing this problem and i believe this is actually the last bit of the puzzle!

Thank you.

You should use left join by putting volkswagen_clients within the first within the from list, then other tables adopted after left join. The left join can join only two tables a treadmill "result set" along with a table,in which the result set is caused by the previous join.

Inside your situation:

SELECT 
    T0.client_id, name, exts, vms, ivrs, queues, conf10, conf20, conf30
FROM 
    vw_clients T0
    left join  vw_exts T1 on T0.client_Id=T1.client_id
    Left join  vw_vms T2 on ...
    ...
Where ...

Maybe here you do not need where clause.

Yes, you’d just replace your WHERE having a LEFT JOIN.

LEFT JOIN vw_exts ON vw_clients.client_id = vw_exts.client_id

You'll be able to remove individuals extra tables in the FROM part.