CREATE OR REPLACE VIEW bdip.bdip_all AS
	SELECT 'Jupiter' as target, 
		index as index, 
		observatoire as observatoire,
		code_obs as code_obs,
		incertitude_obs as incertitude_obs,
		date as date,
		heure as heure,
		observateurs as observateurs,
		instrument as instrument,
		diametre as diametre,
		LCM1 as LCM1,
		LCM2 as LCM2,
		DE as DE,
		PHA as PHA,
		L as L,
		filtre as filtre,
		nb_images as nb_images,
		commentaire as commentaire,
		lien_image as lien_image,
		RA as RA,
		Dec as Dec,
		distance as distance,
		phase as phase,
		solar_elongation as solar_elongation,
		julian_date as julian_date
	FROM bdip.bdip_jupiter UNION
	SELECT 'Mars' as target, 
		index as index, 
		observatoire as observatoire,
		code_obs as code_obs,
		incertitude_obs as incertitude_obs,
		date as date,
		heure as heure,
		observateurs as observateurs,
		instrument as instrument,
		diametre as diametre,
		LCM1 as LCM1,
		LCM2 as LCM2,
		DE as DE,
		PHA as PHA,
		L as L,
		filtre as filtre,
		nb_images as nb_images,
		commentaire as commentaire,
		lien_image as lien_image,
		RA as RA,
		Dec as Dec,
		distance as distance,
		phase as phase,
		solar_elongation as solar_elongation,
		julian_date as julian_date
	FROM bdip.bdip_mars UNION
	SELECT 'Mercury' as target, 
		index as index, 
		observatoire as observatoire,
		code_obs as code_obs,
		incertitude_obs as incertitude_obs,
		date as date,
		heure as heure,
		observateurs as observateurs,
		instrument as instrument,
		diametre as diametre,
		LCM1 as LCM1,
		LCM2 as LCM2,
		DE as DE,
		PHA as PHA,
		L as L,
		filtre as filtre,
		nb_images as nb_images,
		commentaire as commentaire,
		lien_image as lien_image,
		RA as RA,
		Dec as Dec,
		distance as distance,
		phase as phase,
		solar_elongation as solar_elongation,
		julian_date as julian_date
	FROM bdip.bdip_mercure UNION
	SELECT 'Saturn' as target, 
		index as index, 
		observatoire as observatoire,
		code_obs as code_obs,
		incertitude_obs as incertitude_obs,
		date as date,
		heure as heure,
		observateurs as observateurs,
		instrument as instrument,
		diametre as diametre,
		LCM1 as LCM1,
		LCM2 as LCM2,
		DE as DE,
		PHA as PHA,
		L as L,
		filtre as filtre,
		nb_images as nb_images,
		commentaire as commentaire,
		lien_image as lien_image,
		RA as RA,
		Dec as Dec,
		distance as distance,
		phase as phase,
		solar_elongation as solar_elongation,
		julian_date as julian_date
	FROM bdip.bdip_saturne UNION
	SELECT 'Venus' as target, 
		index as index, 
		observatoire as observatoire,
		code_obs as code_obs,
		incertitude_obs as incertitude_obs,
		date as date,
		heure as heure,
		observateurs as observateurs,
		instrument as instrument,
		diametre as diametre,
		LCM1 as LCM1,
		LCM2 as LCM2,
		DE as DE,
		PHA as PHA,
		L as L,
		filtre as filtre,
		nb_images as nb_images,
		commentaire as commentaire,
		lien_image as lien_image,
		RA as RA,
		Dec as Dec,
		distance as distance,
		phase as phase,
		solar_elongation as solar_elongation,
		julian_date as julian_date
	FROM bdip.bdip_venus 
	ORDER by index, date, heure;
