Re: not enough rows, too many rows, and joins

From: <ford_desperado_at_yahoo.com>
Date: 23 Feb 2005 08:50:18 -0800
Message-ID: <1109177418.014873.95560_at_f14g2000cwb.googlegroups.com>

select

person.name, person.gender,
(select min(vehicle.colour) from vehicle where person.id = vehicle.owner and vehicle.type = 'car') color from

if you don't like min, feel free tor eplace it with anything else, just make sure the subselect always returns 1 value Received on Wed Feb 23 2005 - 17:50:18 CET

This message: [ Message body ]
Next message: Roy Hann: "Re: not enough rows, too many rows, and joins"
Previous message: bugbear: "not enough rows, too many rows, and joins"
In reply to: bugbear: "not enough rows, too many rows, and joins"
Next in thread: Neo: "Re: not enough rows, too many rows, and joins"
Reply: Roy Hann: "Re: not enough rows, too many rows, and joins"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message