[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1309
  • Last Modified:

select * from table a, table b?

A very junior question:
What's the real meaning of select from two tables?
Like select * from table a, table b? (not joining them together)?
0
heyday2004
Asked:
heyday2004
  • 2
1 Solution
 
HuyBDCommented:
That cross join 2 tables, each row of each table will join all row with other table
0
 
HuyBDCommented:
It will return the multiplier of rows.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now