Q&A about the site for people seeking specific hardware recommendations
-- Show high-scoring questions and who wrote them. -- The JOIN specifies the matching value (owner ID on a post = user ID). -- This is how SQL connects entries in multiple tables. -- With the addition of JOIN we now need to say which table each column -- comes from in the SELECT statement; note the prefixes. SELECT b.* FROM Badges b JOIN Users u ON b.UserId = u.Id WHERE b.UserId = 1961728