User`s guide

Import Data from Databases into MATLAB
6-5
[ 3] 'Slinky'
[10] 'Teddy Bear'
Close the cursor object and database connection.
close(curs)
close(conn)
Import Data Using Multiple Joins in the SQL Query
Connect to the Microsoft Access database with the data source name dbtoolboxdemo
using the JDBC/ODBC bridge.
conn = database('dbtoolboxdemo','','');
Create an SQL script file named salesvolume.sql with this SQL query. This SQL
query uses multiple joins to join these tables in the dbtoolboxdemo database:
• producttable
• salesvolume
• suppliers
The purpose of the query is to import sales volume data for suppliers located in the
United States.
SELECT salesvolume.January
, salesvolume.February
, salesvolume.March
, salesvolume.April
, salesvolume.May
, salesvolume.June
, salesvolume.July
, salesvolume.August
, salesvolume.September
, salesvolume.October
, salesvolume.November
, salesvolume.December
, suppliers.Country
FROM ((producttable
INNER JOIN salesvolume
ON producttable.stockNumber = salesvolume.StockNumber)
INNER JOIN suppliers
ON producttable.supplierNumber = suppliers.SupplierNumber)
WHERE suppliers.Country LIKE 'United States%'