Skip to content

Content Tagged "easy"

Page 1 of 1

Content Tagged "easy"

Select Rows Where Value from One Column Matches Other Column

November 23, 2016Categories: Software, Tutorial
TL;DR: Use a JOIN . I've got a table representing a tree, using two columns: and I want to select all children for parents whose CLASS_ID have a certain value (e.g. abcd ). The way I could do it was via a JOIN statement: This will: Perform a join where child.parent_prop_id = parent.prop_id…

All tags