alter procedure "dba".FIND(in FString char( 256 ))
result(ColName char( 256 ),FindStr char( 256 ),ID integer)
begin
  select 'VIN',AUTOVIN,IDSALE into ColName,FindStr,
    ID from SALE_FULL_VIEW
    where AUTOVIN like FString;
  select 'Êëèåíò',KLIENT,IDSALE into ColName,FindStr,
    ID from SALE_FULL_VIEW
    where KLIENT like FString;
  select 'Íàèìåíîâàíèå âàëþòû',NAIMENOVANIEVALYTU,IDSALE into ColName,FindStr,
    ID from SALE_FULL_VIEW
    where NAIMENOVANIEVALYTU like FString;
  select 'Öåíà',PRICE,IDSALE into ColName,FindStr,
    ID from SALE_FULL_VIEW
    where PRICE like FString;
  select 'Äàòà ïðîäàæè',DATEOFSALE,IDSALE into ColName,FindStr,
    ID from SALE_FULL_VIEW
    where DATEOFSALE like FString;
  select 'Êëèåíò',KLIENT,IDSALE into ColName,FindStr,
    ID from SALE_FULL_VIEW
    where KLIENT like FString;
  select 'Ïîñòàâùèê',POSTNAIM,IDSALE into ColName,FindStr,
    ID from SALE_FULL_VIEW
    where POSTNAIM like FString;
  select 'Ïðîèçâîäèòåëü',PROIZNAIM,IDSALE into ColName,FindStr,
    ID from SALE_FULL_VIEW
    where PROIZNAIM like FString
end

alter view
  "dba".SALE_FULL_VIEW(IDSALE,
  AUTOVIN,
  MARKAUTO,
  MODAUTO,
  KLIENT,
  NAIMENOVANIEVALYTU,
  PRICE,
  DATEOFSALE,
  POSTNAIM,
  PROIZNAIM)
  as select SALE.IDSALE,INFOAUTO.VIN as AUTOVIN,INFOAUTO.MARKAUTO,INFOAUTO.MODELAUTO as MODAUTO,INFOKLIENT.KLIENT,VALUTA.NAIMENOVANIEVALYTU,SALE.PRICE,SALE.DATEOFSALE,POSTAVCHIK.NAZVANIE as POSTNAIM,PROIZVODITEL.NAZVANIE as PROIZNAIM
    from "dba".POSTAVCHIK right outer join
    "dba".SALE on(POSTAVCHIK.ID_POSTAVCHIKA=SALE.ID_POSTAVCHIKA) left outer join
    "dba".PROIZVODITEL on(SALE.ID_PROIZVODITELIA=PROIZVODITEL.ID_PROIZVODITELIA) left outer join
    "dba".INFOAUTO on(SALE.VIN=INFOAUTO.VIN) left outer join
    "dba".INFOKLIENT on(SALE.KODKLIENTA=INFOKLIENT.KODKLIENTA) left outer join
    "dba".VALUTA on(SALE.KODVALYTU=VALUTA.KODVALYTU)

CREATE TABLE Sale
(                                  
IDSale                    INTEGER                 NOT NULL,
VIN          INTEGER                 NOT NULL,   
MarkAuto               CHAR( 100 )    NOT NULL,
ModelAuto            CHAR( 100 )    NOT NULL,
KodKlienta                INTEGER                 NOT NULL,
KodValytu               INTEGER                 NOT NULL,
Price                       DOUBLE   NOT NULL,
DateOfSale          CHAR( 100 )               NOT NULL,
ID_postavchika   INTEGER         NOT NULL,
ID_proizvoditelia INTEGER     NOT NULL ,
PRIMARY KEY(IDSale)
);