Member Avatar for Pam Thomas

:

CREATE TABLE CUSTOMERS (
    CUSTOMER_ID numeric(3) not null,
    LASTNAME varchar(50) not null, 
     FIRSTNAME varchar(50) not null, 
     STREET_ADDRESS varchar(50) not null, 
     CITY varchar(50) not null, 
     STATE char(2) not null, 
     ZIPCODE char(5) not null, 
     E_Mail varchar(50) null,
     Primary_Phone char(12) null,
     CURRENT_BALANCE real(8,2) not null, 
     CREDIT_LIMIT real(8,3) not null,
     SALES_REP_ID numeric(3) not null,
     PRIMARY KEY (CUSTOMER_ID),
     FOREIGN KEY (SALES_REP_ID) REFERENCES SALES_REPS (SALES_REP_ID));

Hello, Once I create this table how can I take Credit_limit and current_balance and determine how much money customers have left. I want to consolidate the two balances together.

Edited by pritaeas because: Fixed markdown.
  • 2 Contributors
  • 1 Reply
  • 278 Views
  • 5 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

Show what data you have in your table, and how you want the result to look.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.