Re: need help with query

Well, it sounds like homework to me...
In either case a great place to start learning is the documentation... so if you are working with Oracle, become familier with the technet.oracle.com site.
Accounts are free so sign up and begin learning.

For the select statement see:
http://technet.oracle.com/doc/lite/sqlref/html/sqcom.htm#1022553

regards,
cindy

Angry Garden Salad wrote:

> Hi,
> I'm running oracle 8.1.6 on solaris and I need help with an sql
> statement. I have 3 tables with the exact same columns in them, the only
> difference between the tables is the name and the data. Table A contains
> today's data and Table B contains yesterdays data and Table C contains the 2
> days ago. The tables look as follows:
>
> TABLE A
> Date
> RecordType
> RecordName
> RecordCity
> Data1
> Data2
> Data3
>
> TABLE B
> Date
> RecordType
> RecordName
> RecordCity
> Data1
> Data2
> Data3
>
> TABLE C
> Date
> RecordType
> RecordName
> RecordCity
> Data1
> Data2
> Data3
>
> I'd like to have my query return the follow:
> A.RecordType, A.RecordName, A.RecordCity, A.Data1, B.Data1, C.Data1
> Can someone help me with my sql statement?
>
> thanks for help.
Received on Tue Sep 11 2001 - 19:42:38 CDT