Can any one please help me with following qeury

CDDB IS A TABLE
FCS_DIVISION IS A TABLE

I have a domian class mapped to CDDB table , no class mapped to FCS_DIVISION

I need a list of CDDB classes and FCS_DIVISION.FCSD_DESCRIPTIONs

SELECT CDDB.DEALER_NUM
CDDB.DEALERNAME,
CDDB.ADDRESS,
CDDB.CITY,
CDDB.STATE,
CDDB.ZIPCODE,
CDDB.TELEPHONE,
CDDB.PARTS_ACCT_NO,
CDDB.ZONE,
CDDB.DIVISION,
CDDB.DISTRICT ,
FCS_DIVISION.FCSD_DESCRIPTION
FROM CDDB, FCS_DIVISION
WHERE CDDB.DISTRICT = FCS_DIVISION.FCSD_CODE

thanks and regards,
Vinaypal Vemula

Also map the other table.