subject:"\[SQL\] max value from join"

Re: [SQL] max value from join

2004-06-14 Thread Richard Poole

On Mon, Jun 14, 2004 at 11:02:06AM -0500, hook wrote: > I have a court program with related tables > I am trying to extract data related to the last conttinue date using > select >c.citkey, /* c.cdate, >c.badge, c.vioDesc, >b.lname, b.fname,b.mi, b.race, b.dob, b.

[SQL] max value from join

2004-06-14 Thread hook

I have a court program with related tables citation citkey varchar(16) NOT NULL PRIMARY KEY, cdefendant citkey varchar(16) NOT NULL PRIMARY KEY references citation, ccourt citkey varchar(16) NOT NULL PRIMARY KEY references citation, disposition citke