PL/SQL (MOSC)

MOSC Banner

Help on table joins

in PL/SQL (MOSC) 6 commentsAnswered ✓

Hello All,

I am novice to databases and have just started learning about the SQL.

I have the read only access of our production (PeopleSoft HCM). As a starter I am executing basic SQL queries.

I query data from sysadm.ps_tablename. (if I query single table, it works fine)

I want to extract data from two table using a inner join. But the problem is that, I am not able to to do that so.

My question is that is it possible that the sysadm.ps_tablename limits the functionality of Inner join ?

I am using SQL developer.

---

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center