Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 3 of 3
Search took 0.00 seconds.
Search: Posts Made By: disel2010
Forum: Oracle March 7th, 2011, 09:22 AM
Replies: 5
Views: 3,604
Posted By disel2010
Hi arbab, the outer join gives the same...

Hi arbab,


the outer join gives the same result as the inner join because all your primary keys of tblaccount are present in tblcustchannelacct.

(As said before, an outer join works as "fill...
Forum: Oracle March 7th, 2011, 04:34 AM
Replies: 5
Views: 3,604
Posted By disel2010
Hi arbab, and does the inner join (without...

Hi arbab,

and does the inner join (without the plus sign) also give you the same number?
Then you are probably just looking at duplicate entries of the same account_id... (guessing the relation...
Forum: Oracle March 1st, 2011, 01:48 AM
Replies: 5
Views: 3,604
Posted By disel2010
Hi, if you only want records matching...

Hi,

if you only want records matching tblaccounts and tblcustchannelacct you should use an inner join:

Select tab1.ACCOUNT_ID, tab2.ACCOUNT_ID
from tblaccount tab1, tblcustchannelacct tab2...
Showing results 1 to 3 of 3

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.