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 take you more in-depth into how to join 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.