houghi wrote:
> How can I achieve this? I have looked, yet when I try I get an error
> that there is more then one line.

Obviously, just when I send post, I find the answer. Just do the
following 5 times with an increasing LIMIT

SELECT `StoreNumber`, `StoreName`, `Address`, `ZipCode`, `City`,
`StorePhone` FROM `stores` WHERE `StoreNumber` = (
SELECT `store_id`
FROM `distance`
WHERE `postcode` =3000
ORDER BY `distance` ASC
LIMIT 0 , 1
)

It works, however I can imagine there is a nicer way.

houghi
--
They say pesticides have been linked to low sperm counts.
In my opinion if you have bugs down there that are so bad
you need to use a pesticide, you're not gonna get laid anyway.