Программирование в среде VisualFoxPro. Создание базы данных «Зоопарк», страница 5

  Animals.sp_money_min as "Вклад_cпонсора_от", Animals.sp_money_max as "Вклад_спонсора_до", Country.name as "Страна";

 FROM  data1!animals LEFT OUTER JOIN data1!country ON Animals.country_id = Country.id;

    LEFT OUTER JOIN data1!detachment ON Animals.detachment_id = Detachment.id ;

    LEFT OUTER JOIN data1!kind ON Animals.kind_id = Kind.id ;

 ORDER BY Animals.name

Вывод животных с сортировкой по стоимости:

SELECT Animals.id, Animals.name as "Имя",;

  Detachment.name as "Отряд", Kind.name as "Вид", Kind.location as "Место_обитания", Kind.unique as "Редкость",;

  Animals.gender as "Пол", Animals.year as "Год_рождения",;

  Animals.cost as "Стоимость", Animals.date as "Дата_приобретения", Animals.ill as "Больное", Animals.pregnat as "Беременное", Animals.sp_name as "Спонсор",;

  Animals.sp_money_min as "Вклад_cпонсора_от", Animals.sp_money_max as "Вклад_спонсора_до", Country.name as "Страна";

 FROM  data1!animals LEFT OUTER JOIN data1!country ON Animals.country_id = Country.id;

    LEFT OUTER JOIN data1!detachment ON Animals.detachment_id = Detachment.id ;

    LEFT OUTER JOIN data1!kind ON Animals.kind_id = Kind.id ;

 ORDER BY Animals.cost

Вывод животных с сортировкой по дате приобретения:

SELECT Animals.id, Animals.name as "Имя",;

  Detachment.name as "Отряд", Kind.name as "Вид", Kind.location as "Место_обитания", Kind.unique as "Редкость",;

  Animals.gender as "Пол", Animals.year as "Год_рождения",;

  Animals.cost as "Стоимость", Animals.date as "Дата_приобретения", Animals.ill as "Больное", Animals.pregnat as "Беременное", Animals.sp_name as "Спонсор",;

  Animals.sp_money_min as "Вклад_cпонсора_от", Animals.sp_money_max as "Вклад_спонсора_до", Country.name as "Страна";

 FROM  data1!animals LEFT OUTER JOIN data1!country ON Animals.country_id = Country.id;

    LEFT OUTER JOIN data1!detachment ON Animals.detachment_id = Detachment.id ;

    LEFT OUTER JOIN data1!kind ON Animals.kind_id = Kind.id ;

 ORDER BY Animals.date

Вывод животных с сортировкой по отряду:

SELECT Animals.id, Animals.name as "Имя",;

  Detachment.name as "Отряд", Kind.name as "Вид", Kind.location as "Место_обитания", Kind.unique as "Редкость",;

  Animals.gender as "Пол", Animals.year as "Год_рождения",;

  Animals.cost as "Стоимость", Animals.date as "Дата_приобретения", Animals.ill as "Больное", Animals.pregnat as "Беременное", Animals.sp_name as "Спонсор",;

  Animals.sp_money_min as "Вклад_cпонсора_от", Animals.sp_money_max as "Вклад_спонсора_до", Country.name as "Страна";

 FROM  data1!animals LEFT OUTER JOIN data1!country ON Animals.country_id = Country.id;

    LEFT OUTER JOIN data1!detachment ON Animals.detachment_id = Detachment.id ;

    LEFT OUTER JOIN data1!kind ON Animals.kind_id = Kind.id ;

 ORDER BY Animals.detachment_id

Вывод животных с сортировкой по виду:

SELECT Animals.id, Animals.name as "Имя",;

  Detachment.name as "Отряд", Kind.name as "Вид", Kind.location as "Место_обитания", Kind.unique as "Редкость",;

  Animals.gender as "Пол", Animals.year as "Год_рождения",;

  Animals.cost as "Стоимость", Animals.date as "Дата_приобретения", Animals.ill as "Больное", Animals.pregnat as "Беременное", Animals.sp_name as "Спонсор",;

  Animals.sp_money_min as "Вклад_cпонсора_от", Animals.sp_money_max as "Вклад_спонсора_до", Country.name as "Страна";

 FROM  data1!animals LEFT OUTER JOIN data1!country ON Animals.country_id = Country.id;

    LEFT OUTER JOIN data1!detachment ON Animals.detachment_id = Detachment.id ;