join from multiple tables
От | Terry |
---|---|
Тема | join from multiple tables |
Дата | |
Msg-id | 8ee061011003040926j76b4ab9egee231534592dc9f8@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: join from multiple tables
|
Список | pgsql-general |
I have 4 tables: dsclient_logs,backup_sets,dsbox,customer. I want a query that will return all rows from dsclient_logs, insert two columns from the customer table, and one column from backup_sets. The relation is this: dsclient_logs.userid = dsbox.dsbox_snum AND backup_sets.box_id = dsbox.box_id AND dsbox.account_num = customer.account_num I originally had this: SELECT * FROM (SELECT dsclient_logs.ev_id,dsclient_logs.type,dsclient_logs.ev_time,dsclient_logs.category,dsclient_logs.error,dsclient_logs.ev_text,dsclient_logs.userid,dsclient_logs.ex_long,dsclient_logs.client_ex_long,dsclient_logs.ex_text,dsclient_logs.timestamp,backup_sets.set_name,customer.company_name,customer.account_num FROM dsclient_logs,dsbox,backup_sets,customer WHERE dsclient_logs.userid = dsbox.dsbox_snum AND backup_sets.box_id = dsbox.box_id AND dsbox.account_num = customer.account_num ORDER BY dsclient_logs.ev_id desc LIMIT 101) as a ORDER BY ev_id In the end, I want a single row for each ev_id that has the account_num, company_name, and backup_sets filled in. I have a feeling this needs to be done with a different type of join. Horrible explanation so I apologize and will gladly redefine my question upon some feedback.
В списке pgsql-general по дате отправления: