SQL JOINS
From: DCP <vaagh_at_hotmail.com>
Date: Thu, 30 Sep 2004 13:54:59 -0400
Message-ID: <68597cadc5d2e5af2975b61abb8098b1_at_localhost.talkaboutdatabases.com>
I HAVE FOLLOWING CODE
I COUDN'T FIND WHAT'S WRONG WITH IT? select a.name, b.name
from EMP a full outer join EMP2 b
[Quoted] on a.eno=b.eno
Date: Thu, 30 Sep 2004 13:54:59 -0400
Message-ID: <68597cadc5d2e5af2975b61abb8098b1_at_localhost.talkaboutdatabases.com>
I HAVE FOLLOWING CODE
I COUDN'T FIND WHAT'S WRONG WITH IT? select a.name, b.name
from EMP a full outer join EMP2 b
[Quoted] on a.eno=b.eno
gives error at line 3
SQL command not properly ended FULL
*
IF ANY BODY CAN GIVE ME A SOLUTION, I WILL APPRECIATE.
tHANKS
DCP
Received on Thu Sep 30 2004 - 19:54:59 CEST