Tricky Data Insertion

[d.shankar]

I have a table "test" with 2 columns "cars" and "bikes"

 

both are null columns..

 

first i insert for cars as "car1" and leave blank(null) for bikes

 

similarly i add "car2" and again leave blank for bikes

 

Now i add "bike1" and it displays like this as it should

 

cars bikes

car1

car2

      bike1

 

 

but i need to have like this

 

cars bikes

car1 bike1

car2

 

Am i clear ??

[fenway]

No, you're not clear.

[d.shankar]

ok here is the table setup

 

insert into test values("car1","") ; // row 1 created

insert into test values("car2","") ; // row 2 created

insert into test values("","bike1") ; // row 3 created

 

Now the table looks like

 

car1

car2

        bike1

 

 

But i need to have like this

 

car1 bike1

car2

 

 

Any idea ?

 

[fenway]

The table doesn't "look" like anything.  Query it however you desire for your output.

 

And I have no idea what kind of relation there is between these fields.

[revraz]

So you have two columns in one table.  You want to place your Car entry in the first available NULL car column and also place a Bike entry in the first available NULL bike column?

[d.shankar]

yea you got it right bud

[fenway]

yea you got it right bud

Whatever table you're designing, it's wrong.