mysql - is there a way to display only child if it exists or else only parent data

Question

I have two tables and one is parent table and second one is child table both tables has transactions but where as some transactions will take place in parent table and some in child based on their child existence if the parent row doesn't have any child it will be the result and if the parent has the child the child table itself will be the result some times both may occur i tried but not getting the exact solution please help.....

1st table and Parent table

id	item	amount	tax	status
1	4	20	2	Y
2	5	15	1	N
3	6	5	0	N

question from:https://stackoverflow.com/questions/65952798/is-there-a-way-to-display-only-child-if-it-exists-or-else-only-parent-data

Answer 1

SELECT IFNULL(child.item, parent.item) AS item, 
       IFNULL(child.amount, parent.amount) AS amount,
       IFNULL(child.tax, parent.tax) AS tax
FROM parent
LEFT JOIN child ON parent.id = child.p_id