troubleshooting Question

joining tables

Avatar of jamesccnacmp
jamesccnacmp asked on
SQL
7 Comments1 Solution241 ViewsLast Modified:
I am trying to show all data in both tables, I am only seeing HR_tbl  tables not cust_tbl?
select	 "CUST_TBL"."COMPANYNAME" as "COMPANYNAME",
	 "CUST_TBL"."ADDRESS_1" as "ADDRESS_1",
	 "CUST_TBL"."PHONE_OFFICES" as "PHONE_OFFICES",
	 "CUST_TBL"."PHONE_CELL" as "PHONE_CELL",
	 "HR_TBL"."LNAME" as "LNAME",
	 "HR_TBL"."FNAME" as "FNAME",
	 "HR_TBL"."PHONE_HOME" as "PHONE_HOME" 
 from	 "HR_TBL" "HR_TBL",
	 "CUST_TBL" "CUST_TBL" 
 where   "HR_TBL"."CUST_ID"="CUST_TBL"."COMPANYNAME"(+)
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros