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

29 Aug 2019

Review SQL Join, LEFT OUTER JOIN, INNER JOIN

Anonymous

21 Jan 2021

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