[UPHPU] specifying with row is displayed when using MySQL GROUP BY

[Brandon Stout]

-----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-----