is this a homework problem or in any other way related to an academic
exercise?
"Angry Garden Salad" <angry_garden_salad_at_sbcglobal.net> wrote in message
news:Xovn7.5057$dV6.564934869_at_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 - 21:37:44 CDT
