Re: Populating a list from MySQL
Use WorkBench or the mysql client program to develop and debug queries. If the tables don't exist yet, you're working backwards: a crucial part of database design is to write and debug all anticipated queries; that's how you ensure that the db design will be correct for the problems being addressed. Never write app code before the database is designed and proved correct in this way.
See the manual join page for join syntax. It appears you need something like ...
SELECT ...
FROM tblFlights
JOIN tblAirplanes ON tblAirplanes.airplane_ID=tblFlights.airplane_ID
JOIN tblCFI ON tblCFI.cfi_ID=tblFlights.cfi_ID
Subject
Written By
Posted
Re: Populating a list from MySQL
January 14, 2015 01:31PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.