科尔多瓦sqlite连接查询不起作用 [英] cordova sqlite join query not working

问题描述

此查询不适用于cordova s​​qlite:

This query is not working in cordova sqlite :

tx.executeSql("SELECT *
                     FROM cc_user_complaint_status 
                     INNER JOIN cc_manage_departments ON
                     cc_user_complaint_status.department_id = cc_manage_departments.dep_id",[], user_success, user_error);

推荐答案

您可以在此处显示示例的答案.

you can show answer that post here Example..

使用内部联接的SQL，sqlite SELECT

示例:

SELECT doctors.doctor_id,doctors.doctor_name,visits.patient_name             
FROM doctors  
INNER JOIN visits          
ON doctors.doctor_id=visits.doctor_id  
WHERE doctors.degree='MD';

这篇关于科尔多瓦sqlite连接查询不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！