List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 21 1999 9:22am
Subject:Re: Crosstable
View as plain text  
On Tue, 1999-09-21 11:07:17 +0200, Eric Zwart wrote:
> I want to make a crosstable  [...]

Hmm, not quite sure if this is what you mean ...

Suppose, there are two table tab_a and tab_b:

mysql> SELECT * FROM tab_a;         mysql> SELECT * FROM tab_b;
+--------+                          +------+                   
| color  |                          | size |                   
+--------+                          +------+                   
| blue   |                          | S    |                   
| red    |                          | M    |                   
| yellow |                          | L    |                   
+--------+                          +------+                   
3 rows in set (0.02 sec)            3 rows in set (0.00 sec)   

Is this, what you want?

mysql> SELECT color, size FROM tab_a, tab_b;
+--------+------+
| color  | size |
+--------+------+
| blue   | S    |
| red    | S    |
| yellow | S    |
| blue   | M    |
| red    | M    |
| yellow | M    |
| blue   | L    |
| red    | L    |
| yellow | L    |
+--------+------+
9 rows in set (0.02 sec)

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
CrosstableEric Zwart21 Sep
  • Re: CrosstableMartin Ramsch21 Sep
  • Re: CrosstableEric Zwart22 Sep
    • Re: CrosstableArun Bhalla22 Sep
      • Re: CrosstableMartin Ramsch23 Sep
        • triggering an event, by defaultVenky23 Sep