On Wednesday, January 14, 2009, at 03:38PM, "Velda" <[email protected]> wrote:
>Have you tried fixing the join?
Well, if it can be improved, I'd love to improve it:
SELECT pt.*, LPAD(pt.pt_id, 6, '0') as pt_id_padded, pm.pm_name, pv.pv_name
FROM ixd_prodir.prodir_prototypes pt
INNER JOIN ixd_prodir.prodir_modules pm
ON pt.pt_module=pm.pm_id
INNER JOIN ixd_prodir.prodir_prototypes_to_versions ptve
ON pt.pt_id=ptve.ptve_pt_id
INNER JOIN ixd_prodir.prodir_versions pv
ON ptve.ptve_pv_id=pv.pv_id
WHERE pt.pt_pj_id=1
GROUP BY pt.pt_id
ORDER BY pt.pt_name asc
There are multiple records in prodir_prototypes_to_versions for each record in
prodir_prototypes.
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
