Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: a join question
"MadeOfRose" <mehmetgulden_at_gmail.com> wrote in message
news:1138066287.412357.318100_at_g14g2000cwa.googlegroups.com...
> hi all
> is there any way to do that;
> i have 2 tables
> This is table1;
> code1 code2 code3
> --------- -------- ---------
> 9 8 7
>
> This is table2;
>
> Code Description
> --------- ----------------
> 9 Nine
> 8 Eight
> 7 Seven
>
> So,i just wanna do a query that can get descriptions of all field in
> table1 from table2 at same time.
> i did run that,
> select table1.*,table2.* from table1,table2 where
> table1.code1=table2.code
> when i run that i can not get the code2's and code3's description so.
> how can i do that
>
> thanks for any help
>
Fix the data model unless table2 is some sort of generic look up table.
then create 2 more aliases.
Jim
Received on Mon Jan 23 2006 - 20:36:52 CST