How can I transition from tile to stained concrete?
This simplest tile transition is the integral metal edge. It comes in quite a few profiles, some of which can handle a small amount of elevation change. If you need something more elaborate I'd really need more details and hopefully some pictures.