Error adding an item

 

DTSI's picture

I get this error when I try to add an item. Any ideas on how to fix this?

"ERROR: SELECT DISTINCT ON expressions must match initial ORDER BY expressions
LINE 4: SELECT DISTINCT ON ( item_number ) item.*, classcode.*, uo...
^"

AttachmentSize
Screen shot 2011-09-14 at 10.43.53 AM.PNG32.06 KB