need help with query

From: Angry Garden Salad <angry_garden_salad_at_sbcglobal.net>
Date: Tue, 11 Sep 2001 21:31:35 GMT
Message-ID: <Xovn7.5057$dV6.564934869@newssvr17.news.prodigy.com>

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 - 16:31:35 CDT