Re: Combining two row into one

Your request was hard to figure out, but I think I have a start for a
solution.

SELECT DISTINCT A.*, B.*
FROM TheTable As A Inner Join the Table as B
ON A.Date = B.Date

If you have a primary key in the table then you will get multiple rows in
the match. So you will have to remove the primary key from the SELECT
clause by specifying the fields you want.

"Rajat" <Rajat.22jzy0@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:Rajat.22jzy0@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

hi,

iam trying to make a query which will return 1 row with n+n columns
from 2 rows(same table) with n columns each.

the initial table structure would be like this-

Code:
--------------------
date | 12 am | 1 am | 2am | ....... | 11 pm
--------------------


& finally the table should be like

Code:
--------------------
date | 12 am | 1 am | 2am | ....... | 11 pm | x12am | x1 am | x2am |
....... | x11 pm
--------------------


so basically combining two rows from 1st table to 1 row (in new
table/or otherwise)...
i am using VB to execute this query.....so i can construct the query in
VB & then execute it....

-edit:-
actually dont care by column names in 2nd table


sub topic:
the main problem is that....sometimes i need few columns from 1 row and
few from another......
for eg -
on 2/1/2006 - need columns 21pm | 22pm | 23pm <- this is 1 row
while on 2/2/2006 - need columns 12 am | 1 am | 2am | 3am | 4am | 5am
<- 2nd row
i need to combine both these rows & display 1 row with only those
columns....

Trust iam clear. :confused:

TIA


--
Rajat
------------------------------------------------------------------------
Rajat's Profile: http://www.hightechtalks.com/m876
View this thread: http://www.hightechtalks.com/t2349003



.

Relevant Pages

  • Re: Combining two row into one
    ... If you have a primary key in the table then you will get multiple rows ... iam trying to make a query which will return 1 row with n+n columns ... VB & then execute it.... ... Trust iam clear. ...
    (microsoft.public.access.queries)
  • Re: Combining two row into one
    ... So you will have to remove the primary key from the SELECT ... iam trying to make a query which will return 1 row with n+n columns ... VB & then execute it.... ... Trust iam clear. ...
    (microsoft.public.access.queries)
  • What is Indexing in mysql and how it will be useful and how we can retrieve database content easily
    ... Now I am storing data using one primary key and I am just using ... taking long to execute the query. ... some indexing or cluster indexing which might help me but I am not so ...
    (comp.lang.php)
  • Re: Import Automation and...
    ... If there's no existing table, construct and execute a create-table ... query (this is different from a make-table query, ... F2 CHAR CONSTRAINT PrKey PRIMARY KEY, ... construct and execute an append query instead of a make-table query. ...
    (microsoft.public.access.externaldata)
  • Re: Combining two row into one
    ... can be combined into a single query record? ... iam trying to make a query which will return 1 row with n+n columns ... VB & then execute it.... ... Trust iam clear. ...
    (microsoft.public.access.queries)