Table doubt
-
consider i have a two table in Database. if i want to bring first column of both table in the single grid view table that has to be displayed in the user screen, how do i do that..?
-
consider i have a two table in Database. if i want to bring first column of both table in the single grid view table that has to be displayed in the user screen, how do i do that..?
Simple.Use Joins in Sql to get the values and bind it with gridview Check these to know about joins: Joining Tables in SQL[^] Visual Representation of SQL Joins[^]
You have to learn to think like a computer or teach him to think like a human. -Kornfeld Eliyahu Peter
-
Simple.Use Joins in Sql to get the values and bind it with gridview Check these to know about joins: Joining Tables in SQL[^] Visual Representation of SQL Joins[^]
You have to learn to think like a computer or teach him to think like a human. -Kornfeld Eliyahu Peter
thanq so much
-
Simple.Use Joins in Sql to get the values and bind it with gridview Check these to know about joins: Joining Tables in SQL[^] Visual Representation of SQL Joins[^]
You have to learn to think like a computer or teach him to think like a human. -Kornfeld Eliyahu Peter
consider i have 3 table. the solution i need is T1 C1-T2 C2 = T3 C3 T- Table C- column i tried this but doesnt work SELECT advamt,expamt,balance from [advance],[expense],[details] where (advamt-expamt)=balance;
-
consider i have 3 table. the solution i need is T1 C1-T2 C2 = T3 C3 T- Table C- column i tried this but doesnt work SELECT advamt,expamt,balance from [advance],[expense],[details] where (advamt-expamt)=balance;
Sorry for the late reply.I didn't get quite clearly but you have to try something like this
select T1.C1,T2.C2,T3.C3 from Table1 as T1 inner join Table2 as T2
on T1.id = T2.id inner join Table3 as T3 on T2.id =T3.idUse the common columns in between two tables to make joins for your query
You have to learn to think like a computer or teach him to think like a human. -Kornfeld Eliyahu Peter
-
Sorry for the late reply.I didn't get quite clearly but you have to try something like this
select T1.C1,T2.C2,T3.C3 from Table1 as T1 inner join Table2 as T2
on T1.id = T2.id inner join Table3 as T3 on T2.id =T3.idUse the common columns in between two tables to make joins for your query
You have to learn to think like a computer or teach him to think like a human. -Kornfeld Eliyahu Peter
thanq so much. :)