M@,
It seems you've too much info that it leads to (me at least) confusion.
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 and b) you want this result to be unique, but the issue you are having is for each ned_id there are multiple values for data_1.
It looks like you are trying to normalise your data model after the fact.
Have I understood your problem?
select distinct on (ned_id) ned_id, data_1, 3 from nameentry where layoutid in (285,286) and data_1 <> '' and data_1 is not null and client_group_id = 11 and client_id = 1537 ;
--- 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/
