tried this and it doesn't work either

[Shawn B]

SELECT ad.upload
, ad.value AS 'Address'
, cy.value AS 'City'
, st.value AS 'State'
, ap.value AS 'Asking Price'
, ty.value AS 'Type'
, ph.value AS 'Contact Phone'
, bdrms.value AS 'Bedrooms'
, bath.value AS 'Bathrooms'
, sqf.value AS 'Square Footage'
, usn.value AS 'Username'
FROM ezu_uploadinfos AS ad
LEFT JOIN ezu_uploadinfos AS cy ON (ad.upload=cy.upload) AND (cy.name='City')
LEFT JOIN ezu_uploadinfos AS st ON (ad.upload=st.upload) AND (st.name='State')
LEFT JOIN ezu_uploadinfos AS ap ON (ad.upload=ap.upload) AND (ap.name='Asking Price')
LEFT JOIN ezu_uploadinfos AS ty ON (ad.upload=ty.upload) AND (ty.name='Type')
LEFT JOIN ezu_uploadinfos AS ph ON (ad.upload=ph.upload) AND (ph.name='Contact Phone')
LEFT JOIN ezu_uploadinfos AS bdrms ON (ad.upload=bdrms.upload) AND (bdrms.name='Bedrooms')
LEFT JOIN ezu_uploadinfos AS bath ON (ad.upload=bath.upload) AND (bath.name='Bedrooms')
LEFT JOIN ezu_uploadinfos AS sqf ON (ad.upload=sqf.upload) AND (sqf.name='Square Footage')
LEFT JOIN ezu_uploadinfos AS usn ON (ad.upload=usn.upload) AND (usn.name='Username')
WHERE (ad.upload.=usn.upload) = (ad.upload.=usn.upload)