Join Query [message #1896] |
Sun, 09 June 2002 06:02 |
Raja
Messages: 57 Registered: March 2000
|
Member |
|
|
The query is : select a.name,a.sex,b.age from emp a,empr b where a.si = b.si
The question is : Instead of giving the above query , is there any other query like .....select a.*,b.* from emp a, empr b
|
|
|
Re: Join Query [message #1900 is a reply to message #1896] |
Sun, 09 June 2002 11:21 |
Amit Chauhan
Messages: 74 Registered: July 1999
|
Member |
|
|
Hi,
I think you can do this. I have tried this and it works fine for me :
SELECT a.*, b.*
FROM emp a, dept b
WHERE a.deptno = b.deptno
Hope that helps
Thanks
Amit
|
|
|