Member Avatar for naazer.hussain

I have created four tables in apex oracle and I also need to create four statements which display information from all four tables or just a few of the tables, I have tried writing up advanced statements myself but they are not advanced enough, can someone please help?

  • 2 Contributors
  • 1 Reply
  • 143 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by thedubL
Member Avatar for thedubL

If I understand you correctly...Join the tables together to retrieve the results you need. You most likely are going the use a left join.

INNER JOIN: Returns all rows when there is at least one match in BOTH tables
LEFT JOIN: Return all rows from the left table, and the matched rows from the right table
RIGHT JOIN: Return all rows from the right table, and the matched rows from the left table
FULL JOIN: Return all rows when there is a match in ONE of the tables

example:

SELECT column_name(s)
FROM table1
JOIN table2 ON table1.column_name=table2.column_name;

or

SELECT column_name(s)
FROM table1
left JOIN table2 ON table1.column_name=table2.column_name;

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.