Hey there,

This is my sql...

SELECT * ,LEFT(description ,30) As description
FROM auctionpropertyaddressdata LEFT JOIN auctionpropertyimages ON auctionpropertyaddressdata.auctionpropertyid = auctionpropertyimages.auctionpropertyid
ORDER BY propertyprice ASC

how can i limit the number of returned records in the auctionpropertyimages table to ORDER BY RAND() LIMIT 1

so i get all records from auctionpropertyaddressdata and only 1 record from auctionpropertimages table for each auctionpropertyid

Cheers

i don't know if this has been solved but this sounds like u need a subselect
here an e.g.

select *, (select atid from test2 b where a.acid=b.acid ORDER BY RAND() LIMIT 1
) from test1 a 

Hope this will help

thanks for that - but am a bit confused as to the final syntax of the statement

does the atid a set syntax or is a variable for the table ID field?

any help is appreciated

thanks

same issue just different code

i have this so far

SELECT *, (select [b]imagefile[/b]
FROM characterimages b
WHERE a.characterID=b.characterID LIMIT 1 ) from characters a

it is the bold underline part that i am having trouble with as this returns nothing even though the table is in the database

thanks