Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to join 2 tables along with creating a composite key. I am using below script and on reloading, the application throws out an error at composite key creation line. Please help me. Below is the script being used:
BILLDETAILS:
SELECT
BILLDETAILS.BILLNUMBER,
BILLDETAILS.BILLTYPE,
BILLDETAILS.BILLDETAILSLNO,
BILLDETAILS.BILLNUMBER & BILLDETAILS.BILLTYPE & BILLDETAILS.BILLDETAILSLNO as BillDetailKey,
BILLDETAILS.BILLMASTERREFERENCE,
BILLDETAILS.BILLCATEGORYCODE,
CATEGORYMASTER.CATEGORYNAME,
SUPPLIERMASTER.COMPANYNAME,
USERMASTER.USERFULLNAME
FROM BILLDETAILS
Left Outer Join CATEGORYMASTER on (BARCODEDITEMS.CATEGORYID = CATEGORYMASTER.CATEGORYID)
Left Outer Join SUPPLIERMASTER on (BARCODEDITEMS.SUPPLIERCODE = SUPPLIERMASTER.COMPANYCODE)
Left Outer Join USERMASTER on (BARCODEDITEMS.BARCODEDUSERNAME = USERMASTER.USERNAME);
BILLSTONEDETAILS:
Select
BILLSTONEDETAILS.BILLNUMBER,
BILLSTONEDETAILS.BILLTYPE,
BILLSTONEDETAILS.BILLDETAILSLNO,
BILLSTONEDETAILS.BILLNUMBER & BILLSTONEDETAILS.BILLTYPE & BILLSTONEDETAILS.BILLDETAILSLNO as BillDetailKey,
BILLSTONENUMBERS,
BILLSTONEWEIGHT,
BILLSTONERATE
FROM BILLSTONEDETAILS
Try preceding LOAD:
BILLDETAILS:
LOAD *,
BILLDETAILS.BILLNUMBER & BILLDETAILS.BILLTYPE & BILLDETAILS.BILLDETAILSLNO as BillDetailKey;
SELECT
BILLDETAILS.BILLNUMBER,
BILLDETAILS.BILLTYPE,
BILLDETAILS.BILLDETAILSLNO,
BILLDETAILS.BILLMASTERREFERENCE,
BILLDETAILS.BILLCATEGORYCODE,
CATEGORYMASTER.CATEGORYNAME,
SUPPLIERMASTER.COMPANYNAME,
USERMASTER.USERFULLNAME
FROM BILLDETAILS
Left Outer Join CATEGORYMASTER on (BARCODEDITEMS.CATEGORYID = CATEGORYMASTER.CATEGORYID)
BILLDETAILS:
load
BILLDETAILS.BILLNUMBER & BILLDETAILS.BILLTYPE & BILLDETAILS.BILLDETAILSLNO as BillDetailKey,
*
;
SQL SELECT
BILLDETAILS.BILLNUMBER,
BILLDETAILS.BILLTYPE,
BILLDETAILS.BILLDETAILSLNO,
BILLDETAILS.BILLMASTERREFERENCE,
BILLDETAILS.BILLCATEGORYCODE,
CATEGORYMASTER.CATEGORYNAME,
SUPPLIERMASTER.COMPANYNAME,
USERMASTER.USERFULLNAME
FROM BILLDETAILS
Left Outer Join CATEGORYMASTER on (BARCODEDITEMS.CATEGORYID = CATEGORYMASTER.CATEGORYID)
Left Outer Join SUPPLIERMASTER on (BARCODEDITEMS.SUPPLIERCODE = SUPPLIERMASTER.COMPANYCODE)
Left Outer Join USERMASTER on (BARCODEDITEMS.BARCODEDUSERNAME = USERMASTER.USERNAME);
BILLSTONEDETAILS:
load
BILLSTONEDETAILS.BILLNUMBER & BILLSTONEDETAILS.BILLTYPE & BILLSTONEDETAILS.BILLDETAILSLNO as BillDetailKey,
BILLSTONENUMBERS,
BILLSTONEWEIGHT,
BILLSTONERATE;
SQL Select
BILLSTONEDETAILS.BILLNUMBER,
BILLSTONEDETAILS.BILLTYPE,
BILLSTONEDETAILS.BILLDETAILSLNO,
BILLSTONENUMBERS,
BILLSTONEWEIGHT,
BILLSTONERATE
FROM BILLSTONEDETAILS;