Joining 5 tables to extract the required fields

ashimer · Posted: Tue Feb 13, 2007 10:38 am

I HAVE 5 TABLES AND PKS AND FIELDS WHICH ARE REQUIRED FROM THOSE AS FOLLOWS :

TABLE - A
PKS - QUOTN_REF AND CUST_PARTY_ID
FIELDS - COVR_TYPE AND COVR_STT_DT

TABLE - B
PKS - QUOTN_REF ,PRODUCT_ID,CUST_PARTY_ID,REQ_FEATURE_TYPE
FIELDS - FEATURE_RESP_VAL

TABLE - C
PKS - QUOTN_REF,PRODUCT_ID,CUST_PARTY_ID
FIELDS - PURCH_DATE

TABLE - D
PKS - QUOTN_REF, CUST_PARTY_ID, REQ_FEATURE_TYPE
FIELDS - FEATURE_REQ_VAL

TABLE - E
PKS - ASSET_ID
FIELDS - VEH_MAKE,VEH_MODEL,REGTN_NUM

"we can join on table asset_id with table TZUQTRQ_QUOT_REQ
which has a field asset_id"

NOW I NEED THE MENTIONED FIELDS FROM ALL THSE TABLES ... HOW SHUD I JOIN THESE 5 TABLES .... AND THE MAIN THING IS JOINING THE LAST TABLE - E

TIA

Warning: Caps On

ashimer · Posted: Tue Feb 13, 2007 10:44 am

TZUQTRQ_QUOT_REQ TABLE IS TABLE - A ...

THANKS

wanderer · Posted: Tue Feb 13, 2007 11:12 am

I am not sure I understand what are trying to do, and assume that PKS is primary key? and Fields=columns you want to in result set?

Anyway, why is something like the following not possible?

Select ....
from A, B, C, D, E
where
(put your business logic)

Not sure what kind of joins you are looking for.

DavidatK · Posted: Tue Feb 13, 2007 8:52 pm

TIA,

Post what you have so far, I'll critique it for you. You'll learn much more if we work through this together.

vini_srcna · Posted: Wed Feb 14, 2007 2:24 pm

FIRST tell us what kind of join you want..?
INNER JOIN ..?
LEFT OUTER JOIN...?
RIGHT OUTER JOIN ..?
FULL OUTER JOIN ....?