Table With Blank Values

[#1]

Can we have a Table like this with blank rows ??

User_id	Region_ Id	Sub_User_id	Plan_id
1	1
2	2
3	3
		4	1
		4	2
		5	3
		5	4
		6	5
		6	6
		7	7
		7	8
		8	9
		8	10
		9	11
		9	12

User_id	Sub_User_id
1	4
1	5
2	6
2	7
3	8
3	9

[Anonymous]

Well, if you join the two tables (User_id + Region_id and Sub_User_id + Plan_id) you'll create a carthesian product, i.e. every combination of the two tables which seems to be what you're looking for in the resulting table. Be prepared for a lot of combinations if you have more data though when joining tables without any common fields. 1000 rows times 1000 rows quickly becomes one million combinations etc.