how to get values for same column name from two different tables in SQL

how to get values for same column name from two different tables in SQL????

column name is emp_id loacated in these two tables company,employee

View Answers

September 22, 2011 at 5:24 PM

SELECT c.emp_id, e.emp_id FROM company c,employee e
where c.emp_id = e.emp_id;

September 22, 2011 at 5:24 PM

SELECT c.emp_id, e.emp_id FROM company c,employee e
where c.emp_id = e.emp_id;

Ads

Advertisements

sql query to get name,age,phone,address from tables t1,t2,t3,t4,t5 ..
sql query to get name,age,phone,address from tables t1,t2,t3,t4,t5 .. ... , address FROM t1 order by name"; this is for 2 tables : query ="SELECT t.name... by name"; i want for 12 tables : i want to fetch name age pwd phone address from 12

Join the two tables in sql
Join the two tables in sql How to join the two tables in SQL ..and return the value from common column in SQL Database

SQL get Column Name
SQL get Column Name SQL get Column Name is used to return the Fieldnames of the table... get Column Name'. To understand and elaborate example we create a table 'stu

how to get the values from dynamically generated textbox in java?
how to get the values from dynamically generated textbox in java? I have retrieved data from two table both table contains two column and I display... with same pid. I retrieved type field data from both the tables(total records

how to get a column values from a excel file after attaching it - JSP-Servlet
how to get a column values from a excel file after attaching it hi sir, How to get a column values from a excel file after attaching it while... and get a values from that store that value in To input box.Please help me sir

how to add new column before two column in sql.
how to add new column before two column in sql. how to add new column in table before two column in sql. Syntax of Alter table: ALTER TABLE table_name ADD column_name column-definition Suppose, we have a table

how to get multiple hyperlink values from a table column to another jsp file?
how to get multiple hyperlink values from a table column to another jsp file... file named "dbtable" will get the parameter from "index" and search..., itemname, and description. now my itemid column is all in hyperlinks, so

SQL Alter Column Name
SQL Alter Column Name Alter Column Name in SQL is used to change or modify the name... a simple example on SQL Alter Column Name. In this Example, create

How to read text file to two different name array
How to read text file to two different name array I have those numbers:12,4,9,5 numbers:19,12,1,1 how to put it in two different name array in text file to java

inserting same data to different tables in oracle
inserting same data to different tables in oracle Hi there ...! i have to insert un,pwd, to three oracle tables, like admin, user, stud, but i want pickup these table names from a drop down list in html...is there any chance can

SQL Alter Column Name
SQL Alter Column Name Alter Column Name in SQL is used to change or modify the name of column... example on SQL Alter Column Name. In this Example, create a table 'Stu_Table

Updating rows who has same id with different values for each row from java program
Updating rows who has same id with different values for each row from java...) with "lalitha" as a value for sname column from java program. Same for records with sid... rows with same id. student table: sid sname age 2 aruna 25 2

how to retrieve data from table with runtime values in sql?
how to retrieve data from table with runtime values in sql? how to retrieve data from table with runtime values in sql? For example, I have table... value. But I dont know how to retrieve the values whenever i pass different dates

How to update table column from the values of Arraylist in java
How to update table column from the values of Arraylist in java Hii Sir, I have an arraylist containing these values [2, 1, 1, 1, 1, 1, 1... As per my need i have to add these values into different fields of single

java how to get domain name from url
java how to get domain name from url How to get the domain name from a url string? Example program in java for "how to get domain name from url" Thanks Hi, You can use the following example code: URL linkURL

how to get the values to dropdownlist from oracle database
how to get the values to dropdownlist from oracle database </script> </head> <body> <select name... * from countryname"); while(rs.next()){ %> <option value="<

how to get selected name from combo box
how to get selected name from combo box i have fetched all records of worker i.e worker name. on a test.jsp and dispayed it into combo box ...my question is that............. i havt to get particular id of worker on selection

Ads