two table combine

[lonelydragon]

hello, please help.
i have two(maybe more ) tables. i a now trying to create a virtual table basing on the existing tables.
the two tables have no relationship and both have the same number of records(e.g both 5) in the virtual table, i want i have all the fileds of both table and list all the records, the number of reords in the virtual table should be 5 not 10.
i tried times and times, but alway get 10. any one can help?
thanks

 

[johnwm]

If there is no relatiomship between the 2 lots of data, there is not much point in putting the stuff in one table. If it doesn't matter which row from table1 goes with which row from table2, and you've only got 5 rows, then try a full cross join and a LIMIT

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[strucnjak79]

did you try to add this to your virtual table?

'select * from table1, table2'

Like this you select all fields from both tables and it should be OK!



Or I didn't understood your problem well?