Scott Gray wrote:
> Umm... http://svn.ofbiz.org/viewcvs?rev=2202&view=rev :-)

SELECT DISTINCT a.partyId, a.firstName, b.lastName FROM Person a JOIN
FaceAttributes b ON a.partyId = b.partyId WHERE b.faceAttributeTypeId
= 'EGG';

Reply via email to