Delphi Forum

Kod: Tümünü seç

SELECT P.ID, P.STOK_ID, P.PAKET_NU, P.PAKET_ADI, P.ADET AS PAKET_ADET, 
      
       ( P.ADET * S.SATIS_F  ) AS PAKET_SATIS_FIYAT 
FROM PAKET P
LEFT JOIN STOK S ON S.ID = P.STOK_ID

Kod: Tümünü seç

SELECT TIP, ADI FROM 
(
    SELECT 'STOK' AS TIP, ID, ADI FROM STOK

   UNION ALL

   SELECT 'İŞÇİLİK' AS TIP, ID, ISIN_ADI  AS ADI FROM ISCILIK 

   UNION ALL

   SELECT 'HİZMET' AS TIP, ID, ISIN_ADI  AS ADI FROM HIZMET 
) AS ORTAK