Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two tables T1 & T2. there is no common field between the tables. I want join these two table. How can i do It?
Based on your need you can either concatenate your tables and make it one table or when you just join with no common field its joining to create duplicated information.
eg
T1:
no,type
1,a
2,b
3,c
T1:
date,name
23/13,sipho
12/18,kate
Joined table:
no,type,date,name
1,a,23/13,sipho
2,b,23/13,sipho
3,c,23/13,sipho
1,a12/18,kate
2,b,12/18,kate
3,c,12/18,kate
You can still join the tables with LEFT JOIN (T1) LOAD * FROM T2. But you will get a cross join. Basically every field is joined with every possible field value the other table. So this can be a usefull technique if you know what you're doing. But it also can cost a lot of GB RAM and makes your computer stop working.