Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

I am updating the family website, and I've run into a snag with some SQL. I had this working in version 1 of the website, but it required two trips to the DB because I was pulling back a listing of ...