-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Wade Preston Shearer wrote:
> 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 Have you tried SELECT DISTINCT instead of GROUP BY? Brandon -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iEYEARECAAYFAklufnQACgkQx0pgn74qrcL43wCcDj25PUAMagKGT+C5SlQgehiQ uWoAn0ar+kVz6pVV1JKrojMefwm3sj5z =dHzM -----END PGP SIGNATURE----- _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
