All,
I have a table of user addresses that I'm trying to randomly populate
with data from a cities table. Using the following query:
INSERT INTO useraddrs(userid, addrdesc, city, stprov)
SELECT u.userid, 'Home', c.cityname, c.stateabbr
FROM users u, cities c
WHERE u.userid NOT IN (SELECT userid FROM useraddrs)
AND cid=(SELECT cid FROM cities ORDER BY RANDOM() LIMIT 1);
I am able to achieve most of what I am trying to accomplish, but once
the random number is selected, it doesn't change. What am I missing?
Thank you in advance.
-- Gary Chambers
/* Nothing fancy and nothing Microsoft! */