Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training  
 

Query

Ads

 
 

Share on Google+Share on Google+

Karen
Query
0 Answer(s)      6 years and 10 months ago
Posted in : Java Beginners
I would like to a table to display an 80% match between two variables in Parents and Tutors.

In my parents, I have:
ID
Subjects

In Tutors, I have:
ID
Subjects

In my html, I have subjects in options(user can tick more than 1)like this:-
UPS
UPM
UPC
UPE

A tutor can choose to tick UPS and UPC only.

If a parents has ticked UPS, UPM and UPC. If I want to draw out the tutors that consists of UPS and UPS from a tutor, how do I do so?

Parents = UPS UPM UPC UPE and Tutors = UPS and UPC

I can't figure out the query for this till now and have been reading up JSTL and Msaccess query etc...

Really hope to show the way. Many thanks.
Ads
View Answers
Ads









Related Tutorials/Questions & Answers:
query in JDBC
query in JDBC  What are the steps required to execute a query in JDBC
Query conversion
Query conversion  can please convert the following mysql query to hibernate query select * from table1 where field1 not in (select field_1 from table3
Advertisements
query optimization
query optimization  hai ! i need a code in java for database query optimization.plz help
query string
query string  Need some examples of query strings.send me as soon as possible. Regards, R.Santhosh
Query Question
Query Question  How would I write a query to display the name, department of the employee that earns the highest salary in the Employees table
HQL Query
HQL Query  Hibernate query language: How to use a left join in Hibernate query language. Can somebody help with an example. I am getting a unexpected token error in HQL Query tool If I use joins
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
jdbc query
jdbc query  write a query of how to print the values of any column present in database in reverse order
database Query
database Query  i have to find common columns from two tables fron 2 differnt schemas what query to use? i used intersect but i am not getting how it is comapring two tables from different schema because in query we have
database Query
database Query  i have to find common columns from two tables from 2 different schemas what query to use? i used intersect but i am not getting how it is comparing two tables from different schema because in query we have
sql query
sql query  two tables are emp,loc write a query to display all the emp information whose locname not equal to bangalore
session into a query
session into a query  Hi all this am Sreedhar from Hyderabad i am calling one session variable in mysql query but its not working can any one help me please... here is the query.. $query = 'SELECT * FROM post WHERE post_date <
query problem
query problem  how write query in jsp based on mysql table field? i have employee table it contain designation field, how write query in jsp... to write this query in jsp please anybody help me, and send me that code
HQL query
HQL query  how to select only password based on username using HQL query from login table where uname and paswrd are two column names
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
query string
query string  on my servlet page i take the values of the field in a variable and that variable is a primary key so on the basis of that i am sorting... servlet page to different servlet jsp page and that i want to do with query string so
need query
need query  hi sir , i am beginner to sql.i need a query so that it can be helpful to my project. i have four tables each containing different fruits with different amounts. i need a query in such a way that when i say some
sql query
query plz help to me
sql query
query plz help to me
sql query
query plz help to me
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