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)?
Who is Participating?
HuyBDConnect With a Mentor Commented:
It will return the multiplier of rows.
That cross join 2 tables, each row of each table will join all row with other table
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.