Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help..join on two table , Selecting records from two tables
Thanks Rene, I fixed it
Rene Nyffenegger <rene.nyffenegger_at_gmx.ch> wrote in message news:<Xns924CE653C5C4Agnuegischgnueg_at_130.133.1.4>...
> > I am new to Oracle and I am trying to figure out a way to do a select
> > on two tables.
> >
> > Table A
> > --------
> > Col 1A, Col 2A
> >
> > Table B
> > --------
> > Col 1B, Col 2B
> >
> > Here is my query:
> >
> > Select * from TableB where TableA.Col1A=TableB.Col1B and TableA.Col2A
> > <> 1
>
>
> This SQL Statement is invalid. If you want to join TableA and TableB, you
> must include both in the from part of your query:
>
> Select * from TableA, TableB where....
>
> Hth
>
> Rene
Received on Mon Jul 22 2002 - 14:30:29 CDT