Is this possible in sql server 2005?
- by chandru_cp
This is my queries
select ClientName,ClientMobNo from Clients
select DriverName,DriverMobNo from Drivers
It gives me two result tables... But i want to combine both the result tables into a single table... I tried union and union all it doesn't give me what i want....
Note: There is no relationship between the two tables...... There may be 200 clients and 100 drivers...