|
Home > Archive > MS SQL Server > March 2006 > left outer join
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Magnus Österberg 2006-03-06, 7:23 am |
| Hi!
I wish to join two tables.
The first one is:
....which contains the hours from 00 to 23.
The second is this my query, which I would like to return rows also in cases where the Amount of CreationTime is zero. That is, I would like to join in null values from the tblTempVarauksienKel
lonaika-table. But, why doesnät my query do that, as it is?
Magnus
| |
| Perayu 2006-03-06, 7:16 pm |
| You need to select Hour instead of left(B.CreationTime, 2).
Nice picture.
Perayu
"Magnus Österberg" <magnus.osterberg@hotmail.com> wrote in message news:em%233ytRQGHA.532@TK2MSFTNGP15.phx.gbl...
Hi!
I wish to join two tables.
The first one is:
...which contains the hours from 00 to 23.
The second is this my query, which I would like to return rows also in cases where the Amount of CreationTime is zero. That is, I would like to join in null values from the tblTempVarauksienKel
lonaika-table. But, why doesnät my query do that, as it is?
Magnus
| |
| Magnus Österberg 2006-03-10, 7:23 am |
| Still no progress... glad you like my pictures, and I appreciate any further help! :)
Magnus
"Perayu" <yu.he@state.mn.us.Remove4Replay> wrote in message news:uOeDVXTQGHA.3192@TK2MSFTNGP09.phx.gbl...
You need to select Hour instead of left(B.CreationTime, 2).
Nice picture.
Perayu
"Magnus Österberg" <magnus.osterberg@hotmail.com> wrote in message news:em%233ytRQGHA.532@TK2MSFTNGP15.phx.gbl...
Hi!
I wish to join two tables.
The first one is:
...which contains the hours from 00 to 23.
The second is this my query, which I would like to return rows also in cases where the Amount of CreationTime is zero. That is, I would like to join in null values from the tblTempVarauksienKel
lonaika-table. But, why doesnät my query do that, as it is?
Magnus
| |
| Perayu 2006-03-10, 7:23 am |
| Please post the DDL for table tblBooking, and even with the SQL Statement to populate the data to that table.
Perayu
"Magnus Österberg" <magnus.osterberg@hotmail.com> wrote in message news:O6lUmpCRGHA.4452@TK2MSFTNGP12.phx.gbl...
Still no progress... glad you like my pictures, and I appreciate any further help! :)
Magnus
"Perayu" <yu.he@state.mn.us.Remove4Replay> wrote in message news:uOeDVXTQGHA.3192@TK2MSFTNGP09.phx.gbl...
You need to select Hour instead of left(B.CreationTime, 2).
Nice picture.
Perayu
"Magnus Österberg" <magnus.osterberg@hotmail.com> wrote in message news:em%233ytRQGHA.532@TK2MSFTNGP15.phx.gbl...
Hi!
I wish to join two tables.
The first one is:
...which contains the hours from 00 to 23.
The second is this my query, which I would like to return rows also in cases where the Amount of CreationTime is zero. That is, I would like to join in null values from the tblTempVarauksienKel
lonaika-table. But, why doesnät my query do that, as it is?
Magnus
|
|
|
|
|