@Benanov said:There are no explicit joins. There's this idea of where e.g = f.g but that's not the join syntax that's so popular amongst the kids these days. I would also assume that that doesn't allow the server to optimize properly, or at least makes it a hell of a lot harder to do so. A database system that cannot optimize queries with implicitely written joins is not worth its money.I really do not know, but as far as I'm concerned, joins are GOOD.They also encourage one to explicitly enumerate the relationship between the two tables, which does help to align what the hell one is doing firmly in one's head. I wouldn't say explicit joins are bad, but at least I can say I hardly ever use them, and my coworkers also hardly ever use them. We all use implicit joins. Probably a matter of habits.