Search engines are integral features to any well designed website, but how well does your search engine work? Most simple search engines work by querying one column of a database for the search terms.

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 ...