Hi Chris (spelt it right today), Thanks for the reply. > It looks like you are trying to normalise your data model after the fact.
I'm not trying to normalise I'm copying data from 1 table called "nameentry" to another table called "name_entry" "If I understand it correctly, you are a) finding all rows from nameentry (not name_entry) and returning ned_id, data_1 and some constant number 3 " 3 is the data_descriptor_id (the field that the data is copied to) in the "name_entry" table NED_ID is the user, but the user can appear several times in the table, but I only want to copy the user name once "so distinct" Now the problem is I also want to copy over the data_1 value "data_1 as value," Now this is fine if the user is only in the table once, but when the user appears in more then 1 row so does his "data_1" The distinct statement I have distinctly selects the user only once which is good but the problem is the code will go to another row where the user occurs again and ignore the users "ned_id" cos that's distinct but will still grab the users "data_1" Now in the table there is heaps of users who all have a "data_1" in their row, and many may have the same value for the "data_1" column, so I cant do a distinct on the "data_1" column So for example if I have users like this |Ned | data_1 | John 12 Mark 34 John 76 Instead of copying over John, 12 It will copy over "John 1276" --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
