Re: SQL and Grouping

On Mon, 27 Jun 2005 07:43:07 -0700, GerryO wrote:

>
>Thanks for you response to my message. I was unable to get this to work
>still, but I am wondering what the &lt and &gt means.
>
> ON A.[begin] < B.[begin]
> AND A.value <> B.value
>
>Sorry for my lack of experience.

Hi Gerry,

Checking the headers of your message, it appears as if you're using this
group through some Internet portal. And obviously, this portal does some
funny reformatting with the message. I am using a straight feed from a
usenet provider and David's message shows fine for me.

Anyway, &lt and &gt are (when delimited by a semicolon) HTML-versions of
the greater-than and smaller-than sign. If you replace each occurence of
&lt plus semicolon with the smaller-than sign and each &gt plus
semicolon by a greater-than sign, you should get the query as David
posted it.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
.