TW <[EMAIL PROTECTED]> wrote:
> It would look like this:
>
> FName LName Side Height
> ------------------------------
> Igor Tande A 1
> Telly Will B 1
> John Smith A 1
> Bob Hope B 1
> Sandy Rivera A 2
> Bobby Sangria B 2
> Jane Tane A 2
> Tom Jones B 2
>
> SELECT Fname, Lname, Side, Height FROM (SELECT * FROM table WHERE
> Side='A' AND ((Height=1) OR (Height=2)) ORDER BY random() LIMIT 1)
> UNION
> SELECT Fname, Lname, Side, Height FROM (SELECT * FROM table WHERE
> Side='B' AND ((Height=1) OR (Height=2)) ORDER BY random() LIMIT 1)
> UNION
> SELECT Fname, Lname, Side, Height FROM (SELECT * FROM table WHERE
> Side='A' AND ((Height=1) OR (Height=2)) ORDER BY random() LIMIT 1);
Frankly, I don't understand why you would ever need such a beast, and I
probably don't want to know (I suspect it will give me nightmares). In
any case, assuming you really have a reason for this monster, try
something like this:
SELECT Fname, Lname, Side, Height, 1 sequence FROM (SELECT * FROM table
WHERE
Side='A' AND ((Height=1) OR (Height=2)) ORDER BY random() LIMIT 1)
UNION
SELECT Fname, Lname, Side, Height, 2 sequence FROM (SELECT * FROM table
WHERE
Side='B' AND ((Height=1) OR (Height=2)) ORDER BY random() LIMIT 1)
UNION
SELECT Fname, Lname, Side, Height, 3 sequence FROM (SELECT * FROM table
WHERE
Side='A' AND ((Height=1) OR (Height=2)) ORDER BY random() LIMIT 1)
ORDER BY sequence;
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
