ESD esd_tbl.tblname,esd_product_line.productname, esd_install_suite.*, esd_version_lk.version esd_install_suite, esd_tbl, esd_product_line, esd_version_lk esd_install_suite.tbl_id = esd_tbl.id AND esd_install_suite.product_id = esd_product_line.id AND esd_install_suite.version_id = esd_version_lk.id AND ($defaultWhereClause) DISTINCT esd_tbl.id as tbl_id, esd_tbl.tblName as tblname esd_tbl status = 'A' and ($defaultWhereClause) esd_tbl.tblName DISTINCT esd_product_line.id as product_id, esd_product_line.productName as productname esd_product_line status = 'A' and ($defaultWhereClause) esd_product_line.productName DISTINCT v.id as version_id, v.version as version esd_version_lk v status = 'A' and ($defaultWhereClause) v.version