Don, thank you. The SELECT statement worked perfectly just as you
suggested. Though the books I have on MySQL are pretty good, trying
to figure more and more esoteric statements out is a bit of a
challenge, even just in terms of syntax.
Nelson
>
> > In looking via SELECT * FROM tickets, th
On 11-Jul-01 Nelson Goforth wrote:
> I'm trying to return several pieces of information from a small table.
>
> Table is 'tickets':
>
>idCHAR(50)
>group CHAR(50)
>issuedDATE
>used DATE
>
> 'issued' and 'used' are NULL until a date is entered. The found set
I'm trying to return several pieces of information from a small table.
Table is 'tickets':
idCHAR(50)
group CHAR(50)
issuedDATE
used DATE
'issued' and 'used' are NULL until a date is entered. The found set
is generally based on the 'group'.
I want the actual
