Friday, September 16, 2005

22 seconds of your life.


SELECT *

FROM tbl_panel_funder
WHERE cl_funder_id IN
(
SELECT cl_funder_id
FROM tbl_funder_accreditation
WHERE valfirm_id = '7'
)
AND
panel_id = '987657441'

LIMIT 1;


VS


SELECT f.*
FROM tbl_panel_funder f

JOIN tbl_funder_accreditation fa
ON f.cl_funder_id = fa.cl_funder_id


WHERE fa.valfirm_id = ?
AND f.panel_id = ?

LIMIT 1
Post a Comment