Guidewire Interview Question: Write an SQL statement to select the customers from the table and the sales order number from another table.

Notifications

Guidewire

Write an SQL statement to select the customers from the table and the sales order number from another table.

Anonymous

Aug 29, 2019

Review SQL Join, LEFT OUTER JOIN, INNER JOIN

Anonymous

Jan 21, 2021

select c.customerName o.orderNumber from table1 left join table2 ON c.custid = o.custid;