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