Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL sql command question
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Karma
sql command question
1 Answer(s)      3 years and 10 months ago
Posted in : SQL


I have three tables as below: Table 1: options fields: optionsID, optionsCatID, name

Table 2: optionCat fields: optionsCatID, name

Table 3: prodcutOptions fields: pID, optionsID, prodcutID

I designed this tables for multiple prodcut options for ecommerce site. I don't know how good this design is. Anyways I need to find out the sql command which can first see how many type of options are entered for the particular prodcut based on that, i need to get each product options entered for the prodcut.

example: prodcut 1 might have COLOR: blue, black, green and Size: xxl, xl, large prodcut 2 might have only SIZE: large, medium, small prodcut 3 might have only COLOR: green, yellow, black

I would appreciate any help on this.


Advertisement
View Answers

January 21, 2011 at 9:01 PM


any help???



Related Tutorials/Questions & Answers:
sql command question
sql command question  I have three tables as below: Table 1: options fields: optionsID, optionsCatID, name Table 2: optionCat fields: optionsCatID... this design is. Anyways I need to find out the sql command which can first see
ALL command - SQL
ALL Command in Java & SQL  Nee all commands in Java.  Dear Manoj, I didn't get u what do u mean by all command. could u please be a bit clear for understanding ur question. Thank u   VARIOUS COMMANDS
Advertisements
Sql question
Sql question  How to display duplicate values in Sql?   Hi Friend, Please visit the following link: http://www.roseindia.net/sql/mysql-example/mysql-finding-duplicate-records.shtml Thanks
help on mySQL 5 command Line - SQL
help on mySQL 5 command Line  Dear Sir, Sorry for my mistake, please ignore the first post of my question I had created a table for mySQL 5... | +----+------+-------------------------?Ebr /> I want to use the command SELECT WORD, MIN(num
Database Sql question? - WebSevices
Database Sql question?  Given relation r (a, b,c), show how to use the exstended SQL features to generate a histogram of c versus a, dividing a into 20 equal-sized partions (that is where each partition contains 5 percent
how to delete a row in sql without using delete command.
how to delete a row in sql without using delete command.  how to delete a row in sql without using delete command. thanks in advance
Help on mySQL 5 command line - SQL
Help on mySQL 5 command line  Dear Sir, I had created a table... | +----+------+-------------------------? I want to use the command SELECT WORD, MIN(num_of_searches... | +------+----------------------+ What command for MIN should i used
hai this is sql question
hai this is sql question  what are tables in home appliances web application
This Query is no working in sql developer it is giving Ora-0933 exception SQL command not properly ended exception
This Query is no working in sql developer it is giving Ora-0933 exception SQL command not properly ended exception  SELECT * from employees ORDER BY first_name limit 0,10;   Hi Friend, Please clarify your problem
How to Import mysql database command line, Import MySQL dumpfile, SQL datafile into my database ?
How to Import mysql database command line, Import MySQL dumpfile, SQL datafile... command at the shell prompt to import sql data file: $ mysql -u username -p -h...://www.phpzag.com/import-mysql-database-command-line-import-mysql-dumpfile-sql-datafile
Accept command in Oracle
Accept command in Oracle In this section we will see how to use the Accept command in SQL Plus. The ACCEPT command in SQL Plus is used to take the input from... to substitute some value in the sql command. Usage of the ACCEPT command:  ACCEPT
Compute command
Compute command  hello, What is compute command?   hii, samar Compute command control computations on subsets created by the BREAK command
Print command
Print command  Can I use System.out.println command in Struts form bean or Struts action class. I am using Struts 1.3.8 but when I write this command...;You can use System.out.println command in Strut Action Class. The message written
SQL PHP
SQL PHP       SQL PHP.... The function is used to send a query or command to a MySQL connection. Understand with Example The Tutorial illustrate an example from 'SQL PHP'. To understand
question
question   sir plz tell me what should i give in title box. just i want java program for the question typed in this area
question
question   sir plz tell me what should i give in title box. just i want java program for the question typed in this area
iperf command in java
iperf command in java  How to write a code for iperf command in java
Question
Question   When there is an exception in my program how java runtime system handles
c++ system command
c++ system command   c++ system command variables and an example in real time of using the system command
sql
difference between sql and oracle  what is the difference between sql and oracle
sql
sql  how to get first row in sql with using where condition in sql? how to get last row in sql with using where condition in sql
question
question  dear sir/madam my question is how to compare two text format in java..we are java beginners..so we need the complete source code for above mentioned question...we have to compare each and every word
question
question  Dear sir i had some typing mistake at previous question so its my humble request to let me know the steps to start the tomcat6 under the tomcat directory
sql php code
sql php code       SQL PHP code executes the statement using the mysql_query ( ) function. The function is used to send a query or command to a MySQL connection. Understand
sql
sql  I want interview sql questions   Please visit the following link: SQL Tutorials
Command line arguments
Command line arguments  Please explain me what is the use of "command line arguments" and why we need to use
question
question  Dear Sir, could you please send me a simple example of java and database connectivity with java and sql   Please visit the following link: JDBC Tutorials
Sql
Sql  how to find maximum of a101,a102,a103 from a table in sql
question
question  good afternoon, how to get user name and password according to current date,using mysql and jsp.please give me the code immediately.   hi , i think it is easy on executeQuery(); sql query is select uname
SQL
SQL  hii What is sql?   hello, SQL, which stands for Structured Query Language, is a special-purpose language used to define, access, and manipulate data. SQL is non procedural, meaning that it describes
sql
sql  returning value from a store procedure in sql with example   Please visit the following links: http://www.roseindia.net/mysql/mysql5/stored-procedures-and-functions.shtml http://www.roseindia.net/sql/create
Advertisements
 

 

 

DMCA.com