List:General Discussion« Previous MessageNext Message »
From:Claudia M. Castaneda Date:November 16 1999 8:06pm
Subject:a sql query
View as plain text  
I have the following Mysql table:

+----+--------------+-----------------+-------------+-----------+
| id | data_type    | instrument      | platform    | obs_type  |
+----+--------------+-----------------+-------------+-----------+
| 40 | Derived_prod | none            | arcview     | shapefile |
| 41 | Derived_prod | none            | arcvinfo    | e00       |
| 39 | Derived_prod | none            | erdas       | erdas     |
| 42 | Derived_prod | none            | none        | lulc      |
| 35 | Imagery      | Airborne        | hyper       | aisa      |
| 36 | Imagery      | Airborne        | hyper       | aviris    |
| 38 | Imagery      | Airborne        | photo       | air_photo |
| 37 | Imagery      | Airborne        | photo       | doqq      |
| 10 | Imagery      | Satellite       | eos-am1     | aster     |
| 11 | Imagery      | Satellite       | eos-am1     | ceres     |
| 13 | Imagery      | Satellite       | eos-am1     | misr      |
...

| 24 | Imagery      | Satellite       | trmm        | tmi       |
| 25 | Imagery      | Satellite       | trmm        | virs      |
| 34 | Imagery      | Simulation_Data | none        | dew_point |
| 32 | Imagery      | Simulation_Data | none        | max_tm    |
| 31 | Imagery      | Simulation_Data | none        | min_tmp   |
| 33 | Imagery      | Simulation_Data | none        | wind      |
+----+--------------+-----------------+-------------+-----------+

And I would like to write a query, if it is possible, to generate the
following output:

Derived_prod	none		arcview		shapefile
                   		arcvinfo	e00
                   		erdas		erdas
                   		none		lulc
Imagery		Airborne	hyper		aisa
                             			aviris
                       		photo 		air_photo
                             			doqq
              	Satellite	eos-am1		aster
						ceres
						misr

Thank you,

---
Claudia M. Castaneda
Phone 301 286 3397

Thread
a sql queryClaudia M. Castaneda16 Nov
  • Re: a sql queryBob Kline16 Nov