Inner join but based on an inequality

Using the tables sales and salesdetails, write a query that displays orders that were shipped on a date later than the sale. Use a < operater. Remember you must match up the records using sonum in each table so that you can compare sales date to shipping date.

Outer joins in our sql-92 version use the where clause to indicate outer joins.

A left outer join is indicated by *= and a right outer join is indicated by a =*.