sql command question

sql command question

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.

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
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
Advertisements
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
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
hai this is sql question
hai this is sql question  what are tables in home appliances web application
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
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
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
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!ADS
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
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
Question
Question   When there is an exception in my program how java runtime system handles
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
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:ADS_TO_REPLACE_1
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
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
question
question  Gud morning sir, I have asked u some question regarding jsp in saturaday for that i didnot find any answere in which u send me the some of the links.U have asked me the specify some details. There is a entity name
Question?
Question?  My question is how to: Add a menu bar to the program with a File menu. In the File menu, add a submenu (JMenuItem) called About. When the user clicks on the About menu item, display a JOptionPane message dialog
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
sql
sql  I want interview sql questions   Please visit the following link: SQL Tutorials
Sql
Sql  how to find maximum of a101,a102,a103 from a table in sql
SQL PHP
SQL PHP       SQL PHP.... The function is used to send a query or command to a MySQL connection. Understand with ExampleADS_TO_REPLACE_1 The Tutorial illustrate an example from 'SQL PHP
SQL
SQL  hii What is sql?   hello,ADS_TO_REPLACE_1 SQL, which stands for Structured Query Language, is a special-purpose language used to define, access, and manipulate data. SQL is non procedural, meaning
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
SQL
SQL  In my computer i have microsoft sql 2008.how can i set that in the cmd.i want to use that in cmd.what is the default username and password
SQl
SQl  . Given two tables: table1(player, groundname, numcenturies); table2(ground_name, country); Write and SQL query for the following: " Select all the players from table1 who has
SQL
SQL   1)How to Store 1000 records in Oracle object. 2)Write a query for calculate highest, 3rd Highest & 10th highest salary from emp teble. 3)What is Sequence. 4)How to use rowid in Sql. 5)What is Views. 6)How
SQL Error - SQL
SQL Error  Invalid character value for cast specification on column number 5 (Designation) Whats this error about this if the field i specified in programming error. ie DB fields in above question
SQL
SQL  how to get ( 15 march 2011) and (15/03/2011) output using SQL   Use the following queries to get the data from database in the given format. For (15 march 2011) format: SELECT DATE_FORMAT(dob, '%d %M %Y') FROM
SQL
SQL  how to get ( 15 march 2011) and (15/03/2011) output using SQL   Use the following queries to get the data from database in the given format. For (15 march 2011) format: SELECT DATE_FORMAT(dob, '%d %M %Y') FROM
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 Trigger query  Why we use the Trigger and what it's uses?   A database trigger is procedural code that is automatically executed..., user events, and SQL statements to subscribing applications 10)Restrict DML
SQL
tables EMP, and DEPT, the structure for which are given above. Write SQL queries
SQL
events, user events, and SQL statements to subscribing applications 10)Restrict DML
SQL
, user events, and SQL statements to subscribing applications 10)Restrict DML
SQL
events, and SQL statements to subscribing applications 10)Restrict DML
sql - SQL
order by SQL Query  What is order by in SQL and when this query is used in SQL?Thanks!  Hi,In case of mysql you can user following query.Select salary from salary_table order by salary desc limit 3,1Thanks
Compute command
Compute command  hello, What is compute command?   hii, samarADS_TO_REPLACE_1 Compute command control computations on subsets created by the BREAK command
tar command
tar command  Hi, What is tar command in Linux and how it is used? Thanks
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 - SQL
want query? 4.what is the diffrence between sql and plsql?  Hi Friend... HAVING n>1; Difference between SQL and PL/SQL: SQL is a structured query...(select,insert,update etc.), manipulate objects(DDL) and data(DML). PL/SQL
ModuleNotFoundError: No module named 'Question'
command: pip install Question After the installation of Question python...ModuleNotFoundError: No module named 'Question'  Hi, My Python... 'Question' How to remove the ModuleNotFoundError: No module named 'Question
sql - SQL
sql  i have fields as qno,subid,que,op1,op2,op3,op4,ans; and i am having 90 rows in that table .question is am willing to arragnge all the entries... the Query : "select * from question order by qno Asc" For more information
sql - SQL
sql  write a dyamic sql program to display the name of a employee whose salary is <5000  Hi Friend, Use the following query... the following link: http://www.roseindia.net/sql/ Thanks
SQL Plus
SQL Plus  What is SQL Plus?   Hi, Here is the answer,ADS_TO_REPLACE_1 SQL*PLUS is a command line tool where as SQL and PL/SQL language interface and reporting tool. Its a command line tool that allows user to type SQL
Java and SQL - SQL
in getting a data to SQL. my problem is on how to come up with a pop up alert message in the user interface where in the message will be coming from the SQL table. the message was in the SQL table and i want to get that message
SQL - SQL
SQL  Jus c da case we hve certain images in some folder or some area in sql can we create trigger or procedure so dat in front like in asp page while clicking image it will be showed in page ...... ...I mean writing code for each

Ads