MOVE AND DELETE DATA IN TABLE

[pelagic]

Hi all,
I have this table named tblAll, which include the following:
BEFORE BETWEEN AFTER
75 100
75 100
75 100
150 100
150 100
150 100
How would I get the result in one line,
which included:
BEFORE BETWEEN AFTER
75 100 150

Any hints would help,
regards

 

[fluteplr]

select distinct
allbefore.before, allbefore.between, allafter.before after
from tblall allbefore, tblall allafter
where allbefore.between = allafter.between

BTW I would not recommend naming a field between since it is a keyword.

 

[pelagic]

Hi fluteplr,
What is allbefore, allafter mean in this case?
Do you mean tablename tblAll?
thanks,

 

[fluteplr]

They are aliases for the table name (tblall) since I am using the same table twice.

If you look in the from part of the sql statement you will see what I mean.