Can somebody give me an example of the syntax to create a single table view using group by and having? If I have a table with 3 coulums, rdate service and price, and I want the view to show just 1 row for each service and some permutation of the price (such as min, max, last, first, count, etc), what magic sentence would make that view?
TIA Mike Sinclair ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
