Re: Help..join on two table , Selecting records from two tables

> 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

-- 
Latest article on my HP (as of 14.07.2002):
  Transforming each character in a string with perl
  http://www.adp-gmbh.ch/perl/each_char.html