Suppose you want to use data from two tables in a query: tblCustomer and tblOrder. The two tables both have a field - CustomerID - that identifies a customer. Each record in the tblCustomer table may have one or more corresponding records in the tblOrder table - and the corresponding values can be determined by values in the CustomerID field. You now want to join the tables so that the query combines the records from the tables - excluding records from either table if there is no corresponding record in the other table. Which of the following FROM clauses will you use?

Practice this Upwork Skill Test. Freelancers take skill tests on Upwork to show their skills to potential clients and to make themselves more marketable. Upwork suggests you take as many tests as you want -  your skills are shown on your Upwork profile page.