--n-table inner join (Example 1) SELECT * FROM saleslt.customer SELECT * FROM saleslt.customeraddress SELECT * FROM saleslt.address SELECT c.customerid, c.companyname, c.emailaddress, ca.addressid FROM saleslt.customer c INNER JOIN saleslt.customeraddress ca ON c.customerid = ca.customerid SELECT c.customerid, c.companyname, ca.addressid, ca.addresstype, a.addressline1, a.city, a.stateprovince FROM saleslt.customer c INNER JOIN saleslt.customeraddress ca ON c.customerid = ca.customerid INNER JOIN saleslt.address a ON ca.addressid = a.addressid ORDER BY c.customerid ASC --n-table join (example 2) SELECT s.salesorderid, s.salesordernumber, s.totaldue, c.companyname, a.countryregion, a.stateprovince FROM saleslt.salesorderheader s INNER JOIN saleslt.customer c ON s.customerid = c.customerid INNER JOIN saleslt.address a ON s.billtoaddressid = a.addressid
morek3333