canadianpharmning
New Member
Hi i am currently studying sql and I have 2 one to many tables but I do not understand how to combine them to a many to many. I have a joining table.table parentcolumns parent and parent idtable childcolumns child and childidtable parentchild --(Join table selecting parents with childid)columns parentid and childidHere is my codes.\[code\]select parent.name, parentchild.childid from parentjoin parentchildon parent.parentID = parentchild.parentidselect child.name, parentchild.parentid from childjoin parentchild on child.childID = parentchild.childid\[/code\]