Hi guys,

i am faced a problem here where is i need to select a query where the column name is dynamic:

table a

col1 | col2
----------------
A | Ali
B | Abu

Hello, i have face problem when i need to retrieve data from database (SQL 2000). Below my table :

Column A | Column B
1 a
1 b
2 c
2 ...

Thanks for your helping. I get your means and i can get what i want. Thank you very much

Hi Guys ,

i have faced a sql command problem. That is currently i have 2 different table

a) Select ID, Name from Table1 where ID >=1 and ID ID <=3
ID | Name
1 | Alan
...

hello Guys,

I facing a sql query problem which is i need to join many query into one query. That is :

a) SELECT sum(Total) As [MONEY1]
FROM
((SELECT SUM(T1.Amount+T2.Amount) AS Total FROM...

Thanks Help but i think u misunderstood my question. anyway i had found out the answer
select sum(Total) as [Total Amount]
from
(
select T1.Amount+T2.Amount as Total From TABLE1 T1...

Really thanks for ur help. :)
But Now i have new question about this
refered by to ur answer, if let say i wanna to add condition inside this statement, is it possible?
cox when i try :
select...

HI Huang Zhi,

Thanks your help you.
This statement is work!!!

Hi Guys,

I have some confusing part in the sql command

the question is
i have 2 different query :
a) Select SUM(T1.Amount+T2.Amount) as Total From TABLE1 T1 INNER TABLE2 T2 ON T1.ID =...