var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Reducing the number of tables to not more than 4
In the below query, 5 tables are used. I want to replace this query with any number of Select statements with only restriction of NOT MORE THAN 4 TABLES can be used in a single select statement.
Can any one help me in this ? Pls...
My ID is firstname.lastname@example.org. If possible, email me... Thanks alot...
, EXT_CKPR_BPID_GROUP GRUP
, EXT_CKEN_EFT_ENR ENRL
, EXT_CKPR_PROV_EXCEPTIONS EXCP
, EXT_CKPR_PAYMENT_TYPE PAYM
BPID.BPID_PAYEE_ID *= ENRL.PRPR_ID
AND BPID.BPID_PAYEE_ID *= EXCP.PRPR_ID
AND EXCP.PAY_PRINT_IND = 'NOPAY'
AND BPID.BPID_TYPE = GRUP.BPID_TYPE
AND GRUP.PAY_TYPE = PAYM.PAY_TYPE
Why do you want to reduce this to just 4 tables?
Putting your email in a public forum is likely to attract spam - if people feel desperate to do your coursework for you then they could contact you either through a PM or by an internal email by just clicking on your user name.