I have 2 in different schools and it is working out surprisingly well for us. We moved from abroad in June and DS got a place in a new school as an in-year admission, as they were filling up the school. It is slightly out of catchment for us. We rushed to apply for his place and thought there would be no problem for DD to get in for Reception (as implied by school & council as school was so new) so we applied a couple of weeks later for DD only to be told that they were full for Sept and she was on the waiting list!
We decided to wait it out initially as she was number 2 (and 1 for a while) over the summer - (and she is July born, so felt there was no rush to start her) - it is a stressful business, always wondering if you might get the call. However, one day in Sept, I called the council and they let me know that they were processing an application with a higher priority than DD so she would slip down the list - I realised that day that we could be in for a long wait, as the school is on a new estate with people moving ON rather than off. Meanwhile, DD was desperate to start school, so we decided to take a look at the catchment school where she had been allocated a place (which we had deferred) - this school suffers from a poor reputation locally, but just had an Ofsted 'Good' rating.
Long story short, we really liked the school and DD started the following week, went part time for 2 days and begged to go full-time (wasn't in my plan at all LOL) - so now she goes there and LOVES it.
It works for us because DH works from home 3 days a week, and thankfully I have a mum at both schools that I get on with and trust and they help out with pick-ups (this is a blessing cos we are new to the area!) when I need.
This has become an epic post, sorry - what is very interesting to us is how different the schools are - and weirdly, I honestly don't know what I will do when/if we get the call for DD to go to DS's school because the two schools suit their respective personalities and there are things I like about both - the new school has some teething pains and I don't love DS teacher & TA but has good ethos and pastoral care (and good facilities inside but too new outside, no character), DDs school is very established, great outdoors, but 1970s inside & more rough & tumble with really dedicated staff.
Lastly (honest), my DCs are REALLY close, but DS tends to dominate all the games etc and we feel it is great for DD to have her independence, I love the chat at dinner 'in MY school, we do this, what did you do in assembly? etc etc
Sooo, there you have it, our story, with positive overtones I hope!
Good Luck!!