V
V
vickyvdo2020-05-05 02:46:38
SQL
vickyvdo, 2020-05-05 02:46:38

Why is the number of rows in the select * from A cross join B query 16?

I tried to solve the problem here t.me/sqljuniorschool and I don't understand why the maximum number of query strings select * from A cross join B is 16? Tables A and B have 4 terms.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
AUser0, 2020-05-05
@AUser0

Because the maximum result can be such row sets:
A1+B1, A1+B2, A1+B3, A1+B4
A2+B1, A2+B2, A2+B3, A2+B4
A3+B1, A3+B2, A3+B3, A3+B4
A4+B1, A4+B2, A4+B3, A4+B4

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question