find the sql query for the output having two table names ie, homeworklinks,homework_attachments

find the sql query for the output having two table names ie, homeworklinks,homework_attachments

two tables : homeworklinks, homework_attachments homework links table contains two columns like : subject , dateon homework_attachments contains : subjectid, dateon, filename, hwid

the task is:

homeworkattachment records are :

Hindi Assignment 2012-07-24 ESS-INT_Websites.xls 31

Telugu Project 2012-07-25 ESS-INT_Websites.xls 32

Telugu Project 2012-07-25 Daily Status Report_Bhavani.xls 33

Telugu Project 2012-07-25 sql basics data.odt 34

Telugu Project 2012-07-27 ESS-INTWebsiteswithout_Agencies1-2.ods 35

Telugu Project 2012-07-27 DailyTeacherAbsenceBySchool.doc 36

Telugu Project 2012-07-27 hwc doc.doc 37

subject : Hindi Assignment

date_on : 2012-07-24

filename : ESS-INTWebsites.xls

hwid : 31

View Answers

Ads









Related Tutorials/Questions & Answers:
find the sql query for the output having two table names ie, homeworklinks,homework_attachments
find the sql query for the output having two table names ie, homeworklinks... : homeworklinks, homework_attachments homework links table contains two columns like : subject , dateon homework
How to find out the friend user between two columns in sql database
How to find out the friend user between two columns in sql database  Hi, Can any one please tell me ..how to find out the friend user between two columns in sql database? In other words i wanted to get the corresponding data from
Advertisements
SQL HAVING Clause
SQL HAVING Clause      ... The Tutorial illustrates an example from SQL HAVING Clause... is used to create a table Stu_Table. SQL statement to create table
SQL All Column Names
on 'SQL All Column Names'. To understand and grasp the example we create a table... SQL All Column Names       SQL All Column Names is useful when you want to see the Field, Type, Null
SQL QUERY
SQL QUERY  am a having a table 'PROGRAMMER' with columns... C pascal Bhanu Sql... Pascal Sql Mahesh DBASE Cobol
SQL query
SQL query  I need to combine two tables in order to get the values. As an example we have three tables having namely usertable,job table and jobaccess table. In usertable (Userid,Empid,name,Role) details have been stored
sql query
sql query  two tables are emp,loc write a query to display all the emp information whose locname not equal to bangalore
Create table and insert data by sql query
Create table and insert data by sql query... to connect java application and execute sql query like create table in mysql database, insert some values and retrieve values from the table. Before running
Sql Query
Sql Query  Hi M Navjeet Ghai I want to know How to Show A name(Like Navjeet Ghai And Manpreet Singh Sodhi) of employees from a employee table as N.Ghai & M.S.Sodhi by using sql query
Login With Drop Down, Having Departments in different table
in other table. The code provided is having the departments in the same table. Bcoz as per the SQL Query select * from login where username='"+user...Login With Drop Down, Having Departments in different table  Hi all
JDBC : Duplicate records in a table
to find the duplicate records in a table. Duplicate records in a table : You... of table. GROUP BY clause groups record over the field and Having clause.... You can check this by writing  following  SQL query - sql
PHP SQL Output
PHP SQL Output      ... of Sql query execution on the browser. After executing any sql query, you may.... In the example below, we have created sql_output.php where a sql query is executed
output using SQL
output using SQL  how to get ( 15 march 2011) and (15/03/2011) output using SQL   Use the following queries to get the data from database.../%Y') FROM patient; where patient is our table name and dob is a field of date
PHP SQL LIKE Operator
. Output: In the query below, we want to find names which start from s... data in the name column having pattern '%sh%' i.e. The names which have 'sh... below, we want to find names which end with h. $result = mysql_query
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... named 'employee' having three fields id, name and salary. Now we want to add two
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... named 'employee' having three fields id, name and salary. Now we want to add two
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... named 'employee' having three fields id, name and salary. Now we want to add two
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... named 'employee' having three fields id, name and salary. Now we want to add two
Java program to get column names of a table
Java program to get column names of a table... names we need to have connection with the database and then after we will get metadata of this table and find the columns name within the metadata. In our
JDBC- SQL spatio-temporal query
JDBC- SQL spatio-temporal query  Any one give me a JDBC sql query for my spatio temporal query? Trajectory table OBJID PLACE 7 H 8 Q 9 W 10... as shown in above. I want a spatio-temporal query using JDBC-SQL to retrieve
JDBC- SQL spatio-temporal query
JDBC- SQL spatio-temporal query  Any one give me a JDBC sql query for my spatio temporal query? Trajectory table OBJID PLACE 7 H 8 Q 9 W 10... as shown in above. I want a spatio-temporal query using JDBC-SQL to retrieve
Sql Query
Sql Query  Is this query work in Db2 or not ? Select * from FORUM LIMIT 2
Sql Query
Sql Query  Is this query work in Db2 or not ? Select * from FORUM LIMIT 2
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 HAVING Clause
Table Stu_Table The Tutorial illustrates an example from SQL HAVING... SQL HAVING Clause      ... table statement is used to create a table Stu_Table. SQL statement
SQL Alter Table Syntax
SQL Alter Table Syntax       SQL Alter Table Syntax modifies the existing table definition... column_definition,): The Query is used to modify the existing table structure
SQL Alter Table Name
SQL Alter Table Name       SQL Alter Table Name is used to change or modify  name of the existing table. To understand how to change the name of created table in SQL
sql query
sql query  hi friend, Im doing a project,in that a main id... numbers of sids.i want to delete the sid based on the mid.for that i need sql query plz help to me
sql query
sql query  hi friend, Im doing a project,in that a main id... numbers of sids.i want to delete the sid based on the mid.for that i need sql query plz help to me
sql query
sql query  hi friend, Im doing a project,in that a main id... numbers of sids.i want to delete the sid based on the mid.for that i need sql query plz help to me
SQL Query
SQL Query  Selecting the third highest salary of Employee without using any subquery?   Here is a query: SELECT salary FROM employee ORDER BY salary DESC LIMIT 2,1

Ads