[SQL] simple SQL question

Hello All: I would like your input on how I should approach a problem. Say I have a table of companies and one attribute is the market capitalization of these companies. I have another table (definition below) and it contains capitalization levels. For example Micro Cap, Mid Cap, and Lar

[SQL] Postgresql Rules

I have three tables (CUST_CNTCTS, CUST_CO_BILL_ADDR, and CUST_CNTCT_MAILING_LIST_ADDR) using postgresql 8.1.10 CUST_CNTCTS contains contacts for companies we do business with CUST_CO_BILL_ADDR contains billing address for these companies CUST_CNTCT_MAILING_LIST_ADDR associates contacts with add

Re: [SQL] simple SQL question

Mr. McFadyen: Thanks for your quick reply. The coloumns in the SECURITY Table of interest would be: securitykey serial NOT NULL, securitytypekey integer, securitydesc character varying(125), marketcap_usd numeric(19,6) where marketcap_usd would be used to join into capitaliz