"@
<You need to get a listing of all customers and their orders.etStatus@COleDateTimeSpan@@QBE?AW4DateTimeSpanStatus@1@XZ?G
4The ANSI join occurs within the FROM clause of a SQL Select statement. There are many types of joins. Visual FoxPro 4.0 supports a large subset of these join types. The type of join required for this scenario is an Inner Join.

When an inner join occurs, the union (or overlap) of rows between the joined tables are included in the result set. This means that any row from one table that does not have a matching row in the other table is not included. Matches are made according to the columns listed in the ON clause.

This being true, the sample query:

	
�The ANSI join occurs within the FROM clause of a SQL Select statement. There are many types of joins. Visual FoxPro 4.0 supports a large subset of these join types. The type of join required for this scenario is an Inner Join.

When an inner join occurs, the union (or overlap) of rows between the joined tables are included in the result set. This means that any row from one table that does not have a matching row in the other table is not included. Matches are made according to the columns listed in the ON clause.

This being true, the sample query:

	Select customer.cust_id, customer.company, orders.order_id ;
	From customer Join orders on orders.cust_id = customer.cust_id

will return only those customer rows for which there are orders.

Note that when specifying an inner join, you need not include the word "inner".  The word "join", when used alone, is also interpreted as "inner join".em@@UAGJKPAPAG@Z?GetVersion@CPropExchan