How to identify the different records from one table?
Ex: I have a table 'posted records' .This table has parent and child records. For one doc no, the combination is a parent with Children, for another doc no ,it only has children
Can you please suggest me some steps to retrieve "Parent with Child data" records and the "Only child data" records separately.
Thanks in advance,