如何联接两个表 [英] how to join two tables

问题描述

我有两个表，分别是 EventTable 和 VenueTable

I have two tables as EventTable and VenueTable

我将彼此的prinamrykey用作外键.表结构如下；

I m Using prinamrykey of each other as foreignkey. Table structure is as follows ;

EventID|VenueID|EventName 
    1  |    1  | Event1 
    2  |    1  | Event2 
    3  |    2  | Event3 


VenueId|EnevtID|VenueNAme
   1   |   1   | Venue1 
   2   |   2   | Venue2 

我希望得到的结果如下；

and i want the result as follows ;

VenueID | VenueName | EventID | EventName
   1    | Venue1    |  1      | Event1 
   1    | Venue1    |  2      | Event2 
   2    | Venue2    |  2      | Event2
   2    | Venue2    |  3      | Event3

我已经使用内部联接来做到这一点.但是无法获得预期的结果.

I have used inner join to do this., but could not get the expected result.

如何执行此操作?

谢谢..

推荐答案

尝试一下:

SELECT
    v.VenueID,
    v.VenueName,
    v.EventID,
    e.EventName
FROM
    VenueTable v
INNER JOIN
    EventTable e 
    ON (v.EventId = e.EventId)

UNION

SELECT
    v.VenueID,
    v.VenueName,
    v.EventID,
    e.EventName
FROM
    VenueTable v
INNER JOIN
    EventTable e 
    ON (v.VenueID = e.VenueID)

这模拟了MySQL中的FULL OUTER JOIN

这篇关于如何联接两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！