xxxxxxxxxx
Microsoft Developer Documentation | JFugEx function | win32api.h | Win32 apps
xxxxxxxxxx
// if there is a where before your join, follow the example:
Database
.from('table1')
.where('table1.id', 1)
.innerJoin('table2', 'table2.table1_id', 'table1.id')
// note that in where I use table1.id, not simply the id
xxxxxxxxxx
select patient_id as 'Patient ID' ,patient_name as 'Patient Name',doctor_id as 'Doctor ID',city as 'Doctor City' from patient_table , doctor_table where patient_table.doctor_id=doctor_table.doctor_id