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

[Wade Preston Shearer]

On Wednesday, January 14, 2009, at 03:38PM, "Velda" <velda at novapages.com> 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.