内部加入MYSQL查询 [英] Inner Join MYSQL query

问题描述

大家好，

我想知道是否有人可以在这里帮助我...

我有两个桌子:

表1列:

|事件ID |用户ID |事件名称|
------------------------------

表2列:

|用户ID |用户名|密码|显示名称|
------------------------------------------

基本上，我试图从表1中选择所有内容，但在结果中，我需要显示用户名而不是用户ID，并且我知道我必须使用INNER JOIN查询从表中选择用户名2.

我似乎无法正确理解语法...

问候，
Tom.

Hi Everyone,

I''m wondering if any of you can help me here...

I have two tables:

Table 1 Columns:

|Event ID|User ID|Event Name|
------------------------------

Table 2 Columns:

|User ID|Username|Password|Display Name|
------------------------------------------

Basically I''m trying to select everything from Table 1, but in the results, I need to show the Username rather than the User ID, and I know I''d have to use an INNER JOIN query to select the Username from Table 2.

I just can''t seem to get the syntax right...

Regards,
Tom.

推荐答案

如果您不想使用别名，可以尝试一下.

If you don''t want to use alias name than try this.

SELECT TABLE1.EVENTID, TABLE1.EVENTNAME, TABLE2.USERNAME FROM TABLE1  
INNER JOIN TABLE2 ON TABLE1.USERID = TABLE2.USERID;

意见建议:
最好使用别名，这样就不必写整个表名.

Suggestion:
It is better to use alias name so that there is no need of write the whole table name.

Hello

很简单，请在下面的查询中查询对您有帮助

Hello

It''s so simple, check below query it will help to you

Select T1.EventID, T1.EventName, T2.UserName from Table1 T1 Inner join Table2 t2 on T1.UserID = T2.UserID

还可以在下面的链接中找到有关加入的更多信息

http://www.w3schools.com/sql/sql_join.asp [

also find more about the join into below links

http://www.w3schools.com/sql/sql_join.asp[^]

Thanks
Gaurav Dhol

没有问题！!!!

No Issues!!!

Select Table1.EventID, Table1.EventName, Table2.UserName from Table1 Table1 Inner join Table2 Table2 on Table1.UserID = Table2.UserID

问候
〜Karthik〜

Regards
~Karthik~

这篇关于内部加入MYSQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！