I have two tables with no relation between them. The following is a query I've tried:
SELECT table1.columnName, table2.columnName AS newColumn
FROM table1, table2.
I am unable to get the results I need.
-
Please show the column structure of both tables and also what is your expected output ?Purushottam zende– Purushottam zende2014-10-31 05:41:59 +00:00Commented Oct 31, 2014 at 5:41
-
if there is no relation, then just do separate select queryYohanes Khosiawan 许先汉– Yohanes Khosiawan 许先汉2014-10-31 05:42:46 +00:00Commented Oct 31, 2014 at 5:42
-
Right now you are creating a full Cartesian product.PM 77-1– PM 77-12014-10-31 05:43:54 +00:00Commented Oct 31, 2014 at 5:43
Add a comment
|
2 Answers
There can be several queries depends on scenario. However, if you want to join two different columns of two different tables into a single column without WHERE then you can do like:
SELECT CONCAT( table1.col1 , table2.col2) AS colName FROM Table table1,Table table2.
Comments
Assuming you want the columns combined into a single column, without a where clause, that's going to give you a (probably larger than you want) Cartesian product, but you can do it with something like:
select concat (tbl1.col1, tbl2.col2) from tbl1, tbl2
If you want a single column with values from both tables (rather than concatenating them), just use something like:
select col1 as col from tbl1
union
select col2 as col from tbl2
1 Comment
Chinnu
thanKz paxdiablo... second one works for me when used with UNION ALL