MySQL 使用 AND 组合两个 SELECT 语句

Question

两周以来，我一直在尝试将这两个陈述结合起来，但无济于事。我试过使用 UNION 但它会产生“列数不同”错误。现在我希望使用 AND 子句来组合这些语句。提前致谢:)

SELECT te_events.eventTitle,
       te_category.catDesc
FROM te_events
JOIN te_category ON te_events.catID=te_category.catID
ORDER BY te_events.eventTitle

SELECT eventStartDate,
       eventEndDate,
       eventPrice,
       eventDescription
FROM te_events

Answer 1

SELECT e.eventStartDate,
       e.eventEndDate,
       e.eventPrice,
       e.eventDescriptio,
       e.eventTitle,
       c.catDesc
FROM te_events AS e
LEFT JOIN te_category AS c ON e.catID=c.catID
ORDER BY e.eventTitle