The default search term operator is AND
You can use brackets, AND OR and NOT to improve your search. For example: C# AND NOT ( VB or SQL )
A query of a single * will return everything, filtered by any filters.
Search by Author: author:"author name"
Filter by tag: tag:C# or tag:(C++ or Java)
Wildcard search use: "?" or "*" eg. gr?d or gr*
This video will explain how to complete much more complex joints between your tables.
This video from our "SQL Database for Beginners" series will go into more detail about your tables within your database. You will learn about inner joins, outer joins, and self joins, along with complex multi tables joins.