Oracle ODBC Connection - trying join table in the sql statement
Feb 25, 2013 10:35 AM(7032 views)
I would like to select data from more than one Oracle table using "Open Database". I have tried in the past without success so I have been brings back all data into multiple JMP data tables and then using JMP's built in join functionality. Our database tables are getting large so this really slows things down.
SELECT name_db.first, name_db.last, add_db.street, add_db.zip FROM name_db, add_db WHERE name_db.cust_id = add_db.cust_id