PROBLEM: Turn a two-step SELECT procedure into a one-step procedure. The two-step procedure is
1) Discover with a query to a parent table what other rows in the parent table are related to the queried row.
2) Obtain selected data for the queried row and other related rows from the parent table and a child table that are connected by a FOREIGN KEY.
BACKGROUND: I have two tables -- a parent (parent_table) and a child (child_table) table - connected by a valid FOREIGN KEY and an
UPDATE: Since I last posted I have acquired new information and am now well positioned to pose a more precise question.
BACKGROUND: The following query on the above tables yields the data shown below the query.
SELECT * FROM parent_table LEFT OUTER JOIN child_table ON parent_table.id = child_table.id LEFT OUTER JOIN ref_table ON parent_table.id = ref_table.id WHERE parent_table.id = '2'
userbio: I am Beth.