How to join table without using JOIN or any alias? SQL Server

new9mtju 于 2023-03-28 发布在 SQL Server

关注(0)|答案(1)|浏览(196)

I was wondering is it possible to do a join on two tables without using JOIN or any alias for the tables?

For example I usually do:

SELECT * 
FROM table1 a
LEFT JOIN table2 b ON a.column = b.column

From my understanding, the join I did above is ANSI-92 syntax, is this correct?

Is it possible to do this same join without using the JOIN keyword or any alias for the tables? If so, what is this called? And would you also be able to give me an example of what this join would look like based on my example?

Thanks!

sql-server

来源：https://stackoverflow.com/questions/48103135/how-to-join-table-without-using-join-or-any-alias-sql-server

1条答案

按热度按时间

vktxenjb1#

Legacy-style syntax for a left join (SQL Server only):

SELECT  *
FROM    TableA a, TableB b
WHERE   a.Id *= b.Id

But this should never be used.

赞(0）回复(0）举报 2023-03-28

我来回答

How to join table without using JOIN or any alias? SQL Server

1条答案

相关问题

热门标签

最新问答