Regarding retrieve the data from two different tables
-
Hi All, greetings.In my appilcation i need to take two different data that is EmployeeName from Employee Table and ClientName from Client Table.How i can write it in a single SQL Query. Can any one one give me the query please. Thanks in Advance.
Babu
-
Hi All, greetings.In my appilcation i need to take two different data that is EmployeeName from Employee Table and ClientName from Client Table.How i can write it in a single SQL Query. Can any one one give me the query please. Thanks in Advance.
Babu
ChennaiBabu wrote:
In my appilcation i need to take two different data that is EmployeeName from Employee Table and ClientName from Client Table.How i can write it in a single SQL Query.
Try using JOIN. You can find about Joins here[^]
_____________________________ Success is not something to wait for, its something to work for.
-
Hi All, greetings.In my appilcation i need to take two different data that is EmployeeName from Employee Table and ClientName from Client Table.How i can write it in a single SQL Query. Can any one one give me the query please. Thanks in Advance.
Babu
Or you can also use UNION operator to combine data from 2 select statements.... << >>