sql server - SQL Select all columns from multiple tables -

a question in old exam paper reads follows:

suppose have 3 tables (cardholders, cardholder_status, accounts). write query bring possible combinations (cross product) of data.

now guess query this

select * cardholders, cardholder_status, accounts 

will above query return correct results, or lost?

above 1 right . can try

select * cardholders cross apply  cardholder_status cross apply accounts 

or

select * cardholders cross join  cardholder_status cross join accounts