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

Question & Answer
1

Hi Guys,

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

data_set
data_set1454×821 245 KB

Thank for help.

2

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 .

Thanks
Vinod

1 Like
3

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?

4

Are you talking about left / right joins?

1 Like