Hi everyone, I've gotten my hands into programming now after not doing anything like this for maybe 10 years now. I'm working with an Oracle database and I'm just starting to learn how to run SQL queries. I've gotten the basics so far of the select, where functions. But I'm trying to do a little more fancy things, and it's becoming difficult. So I wouldn't mind getting coached throughout this thread. Yeah?
First challenge:
I've been able to write a simple query using and/or statements. Now, I want to group everything in a particular way to reflect the hierarchy that the database is representing. So I need to somehow figure out how to group things according to the proper parents/children. What I'm doing now is trying to figure out which columns control the hierarchy, because it's not clear, and I can't ask anyone here.