I have two tables with an identifying (1:0-N) relationship between the parent and child tables. Is there a way I can do a single select query to get a row from the child table? To me it seems that I must do two queries, one to get the id from the parent table and then another using that id to query the child table.
In another way, the answer to the question is YES. Because you can get A ROW. You may not ALWAYS get A ROW, and you might get A ROW and some other rows, but you "can do a single select query to get a row from the child table".