Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT p.PROD_NAME, pv.PROD_VERS_NAME, cl.COMPA_LVL_NAME
- FROM TBL_PROD AS p, TBL_PROD_VERS AS pv, TBL_PROD_VERS_ALLOC AS pva, TBL_COMPA_LVL AS cl, TBL_COMPA AS c
- WHERE p.PROD_ID=pva.PROD_ID And pv.PROD_VERS_ID=pva.PROD_VERS_ID And cl.COMPA_LVL_ID=c.COMPA_LVL_ID And pva.PROD_VERS_ALLOC_ID=c.PROD_VERS_ALLOC_ID_B
- And p.PROD_ID=66;
- SELECT p.PROD_NAME_A, p.PROD_NAME_B, [....]
- SELECT pa.PROD_NAME, pb.PROD_NAME, pv1.PROD_VERS_NAME, pv2.PROD_VERS_NAME,cl.COMPA_LVL_NAME
- FROM TBL_PROD AS pa, TBL_PROD AS pb,TBL_PROD_VERS AS pv1, TBL_PROD_VERS AS pv2,
- TBL_PROD_VERS_ALLOC AS pva, TBL_PROD_VERS_ALLOC AS pvb,
- TBL_COMPA_LVL AS cl, TBL_COMPA AS c
- WHERE
- pa.PROD_ID=pva.PROD_ID And
- pv1.PROD_VERS_ID=pva.PROD_VERS_ID And
- pva.PROD_VERS_ALLOC_ID=c.PROD_VERS_ALLOC_ID_A And
- pb.PROD_ID=pvb.PROD_ID And
- pv2.PROD_VERS_ID=pvb.PROD_VERS_ID And
- pvb.PROD_VERS_ALLOC_ID=c.PROD_VERS_ALLOC_ID_B And
- cl.COMPA_LVL_ID=c.COMPA_LVL_ID And
- p.PROD_ID=66;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement