Help on table joins
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.
---