-----------------------------------------------------------
New Message on cochindotnet
-----------------------------------------------------------
From: Cenray
Message 1 in Discussion
How to force a join in Oracle SQL Query? Eg: Table : emp
emp_code numeric(5) Primary Key
emp_name varchar2(20)
Table : address
add_emp_code numeric(5) Foreign Key
add_emp_address varchar2(50)
Table emp contains 3 records
Eg: emp_code emp_name
1 aaaaaa
2 bbbbb
3 cccccc
Table address contains 2 records
Eg: add_emp_code add_emp_address
1 xxxxxxxxxxxx
3 zzzzzzzzzzzzzz I want to join
emp table and address table to get details of all emps including address ie the output
should looks like
Eg: emp_code emp_name add_emp_address
1 aaaaaa xxxxxxxxxxxxx
2 bbbbb NULL
3 ccccc zzzzzzzzzzzzzzzz This can
be satisfied in SQL Server with the following Query select emp_code, emp_name,
address.add_emp_address from emp, address where address.add_emp_code =* emp_code;
How this can be satisfied in Oracle?
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/cochindotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
