Hi Bruce,
bruce wrote:
hi...
a further test...
the following test tbl/information:
dog
name char
statusint
_date timestamp
idint
here's the tricky part. if i want to get the row with the status=3, but only
if there's not a status=4 that has a later date, how
0:23 AM
Subject: db/query question...
hi...
a further test...
the following test tbl/information:
dog
name char
status int
_date timestamp
id int
test data
dog
name status_date id
tom 1 01/20/07 1
tom 2 01/21/07 2
sue 1 01/20/07 3
tom 3
hi...
a further test...
the following test tbl/information:
dog
name char
statusint
_date timestamp
idint
test data
dog
name status _dateid
tom 1 01/20/07 1
tom 2 01/21/07 2
sue 1
hi...
a further test...
the following test tbl/information:
dog
name char
statusint
_date timestamp
idint
test data
dog
name status _dateid
tom 1 01/20/07 1
tom 2 01/21/07 2
sue 1
