โดย aei_ou » 24/02/2009 2:49 pm
ลองดูคำสั่ง SQL จากตัวอย่างนี้นะ
SELECT employees.*, departments.deptname
FROM employees, departments
WHERE employees.deptid = departments.deptid
AND ( employees.employeeid LIKE '%colname%'
AND employees.firstname LIKE '%colname%'
AND employees.lastname LIKE '%colname%'
AND employees.email LIKE '%colname%'
AND departments.deptname LIKE '%colname%'
)
ORDER BY firstname ASC
ลองดูคำสั่ง SQL จากตัวอย่างนี้นะ
SELECT employees.*, departments.deptname
FROM employees, departments
WHERE employees.deptid = departments.deptid
AND ( employees.employeeid LIKE '%colname%'
AND employees.firstname LIKE '%colname%'
AND employees.lastname LIKE '%colname%'
AND employees.email LIKE '%colname%'
AND departments.deptname LIKE '%colname%'
)
ORDER BY firstname ASC