SELECT TEMPLATE.ID ID, TEMPLATE.TEMPLATE_NAME TEMPLATE_NAME, TEMPLATE.VERSION VERSION, TEMPLATE.START_DATE START_DATE, TEMPLATE.END_DATE END_DATE, PRODUCT.NAME PRODUCT_NAME FROM OKL_PRODUCTS PRODUCT,OKL_PRD_PRICE_TMPLS TEMPLATE WHERE TEMPLATE.PDT_ID = PRODUCT.ID
SELECT TEMPLATE.ID ID
, TEMPLATE.TEMPLATE_NAME TEMPLATE_NAME
, TEMPLATE.VERSION VERSION
, TEMPLATE.START_DATE START_DATE
, TEMPLATE.END_DATE END_DATE
, PRODUCT.NAME PRODUCT_NAME
FROM OKL_PRODUCTS PRODUCT
, OKL_PRD_PRICE_TMPLS TEMPLATE
WHERE TEMPLATE.PDT_ID = PRODUCT.ID
|
|
|