complex query problem
Posted by: mwm mwm
Date: August 06, 2007 08:13AM

I have a single table that containes payments of home utilities such as water, gas and electric. the tables has accounts numbers for each utility. the homes have address, lot number and its a townhouse it includes unit number. What I need to do is to create one table to have the address, lot, unit, and account number for each utility. then have a second table that will only have the payment records. I don't know how to write a query to do this. any suggestion is much appreciated.

Thank You

CREATE TABLE `Paymentstype` (
`ID` INTEGER NOT NULL,
`community` VARCHAR(255),
`lot` DOUBLE NULL,
`unit` INTEGER,
`address` VARCHAR(255),
`account` VARCHAR(255),
`one` VARCHAR(255),
`two` VARCHAR(255),
`three` VARCHAR(255),
`four` VARCHAR(255),
`five` VARCHAR(255),
`six` VARCHAR(255),
`seven` INTEGER,
`type` VARCHAR(255)
) TYPE=MyISAM;

Options: ReplyQuote


Subject
Written By
Posted
complex query problem
August 06, 2007 08:13AM
August 06, 2007 09:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.