How write query to join two table without any join key?

Hi Guys,

How to write query join two table without any join key ?
please see detail on photo below.

Thank for help.

Hi @Siriphon

Without any join key between the tables , results will get multiplied/duplicated … will that be ok ?

You can write a custom SQL directly on the underlying database without any joins but it will result in duplicates .

select * from Application , Payment .


1 Like

Hi , apjvinod.
Thank for yr answers.
I have another question.

How to join table app form id to get data total premium from payment table if can’t find data will display null or zero as sample photo?

Are you talking about left / right joins?

1 Like