Hi Guys,
I've got 2 tables that look like this:
Table A
ID Name
------------
1 Alpha
2 Beta
Table B
COde City
-------------
4000 Essen
5000 Cologne
the 2 tables have nothing to do with each other. Despite this, I would like a result
alpha, Essen in a dataset.
I just need the syntax. I thought it would work with this:
select name,City from (
select name from A where id=1, select City from B where code=4000)
but this is wrong..!! Please help thanks.
I've got 2 tables that look like this:
Table A
ID Name
------------
1 Alpha
2 Beta
Table B
COde City
-------------
4000 Essen
5000 Cologne
the 2 tables have nothing to do with each other. Despite this, I would like a result
alpha, Essen in a dataset.
I just need the syntax. I thought it would work with this:
select name,City from (
select name from A where id=1, select City from B where code=4000)
but this is wrong..!! Please help thanks.
