> One more try with that query. sorry. It's still $50. > > select distinct field1 from table1 order by field1 > > ^ makes first list > > select field2 where table1.field1 = result from that selection
in not following what you are trying to do and what database you are running the query in. if you could provide some ddl for the tables that would be great too and what you are trying to accomplish. -- ray _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
