Ok, that's gravy then Anno, at least you confirmed it which is the most important part.
With LEFT JOIN you never really can be sure until you run the benchmarks. It depends on the specific query, and the potential speed decrease can vary dramatically from nothing, all the way up to hundreds of times slower, depending on the table structure and what's being done.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
