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
is
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, the
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