Database consists of the following 4 tables with respective
attributes:
CUSTOMER(C#, CUSTOMER NAME, ADDRESS), the key is [C#]
ITEM(I#, ITEM NAME, MANUFACTURER, YEAR), the key is [I#]
BOUGHT(C#, I#, DATE, QUANTITY), the key is [C#, I#,DATE]
PREFER(I#, C#), the key is [I#, C#]
I'm trying to construct the following query (in SQL)
List of customers that bought all the items that John prefers.
I can get the list of all the items that John prefers, but I'm not
sure how to check that list against customers who bought ALL those
items. I'm assuming it's either a division or some sort of subtraction
but I'm not sure how to formulate the SQL query.
Any and all help is appreciated, thanks!
Apr 14 '07
21  1895 
I couldn't find a suitable MySQL (or just SQL group) that was as
active as this one. Thanks though.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: lawrence |
last post by:
I've been bad about documentation so far but I'm going to try to be
better. I've mostly worked alone so I'm the only one, so far, who's
suffered from my bad habits. But I'd like other programmers to have an
easier time understanding what I do. Therefore this weekend I'm going
to spend 3 days just writing comments. Before I do it, I thought I'd
ask other programmers what information they find useful.
Below is a typical class I've...
|
by: JC |
last post by:
I am using Mysql version: 4.0.18-max-log
and trying to populate a database from a text file using source option from
inside the mysql environment.
The population run OK but when creating the indexes i get
< ----- ERROR ------------->
Query OK, 1 row affected (0.00 sec)
|
by: Martijn van Oosterhout |
last post by:
I've had some fun in the past where I've had to grant a lot of tables and
other similar system commands. Unfortunatly, you can't use queries to fill
in fields for you. Anyway, I've implemented a patch which allows the
following:
grant select on ":2" to ":1"
\for select usename, relname from pg_catalog.pg_user, pg_catalog.pg_class where relname not like 'pg_%';
Produces:
|
by: ti33m |
last post by:
Hi All,
I'd like to include a datasheet on my user interface but since I'm
starting to run tight on space, I'd like to have a vertically-oriented
datasheet (column 1 has labels, column 2 has values), i.e. a
transposed datasheet or datasheet in column format. A vertical
datasheet will look cleaner, eliminate the need to scroll across (for
miles) and lay out bit more efficiently since I have some long labels.
It seems like Access only...
|
by: pw |
last post by:
Hi,
I am having a mental block trying to figure out how to code this.
Two tables:
"tblQuestions" (fields = quesnum, questype, question)
"tblAnswers" (fields = clientnum, quesnum, questype, answer)
They are related by quesnum and questype. There are records in
| | |
by: Paul Mendez |
last post by:
I really need some help
Date Code ConCAT Bal_Fwd NS_Fees Amt_Coll Cur_End_Bal
1/15/2004 KW 11KW2003 $500.00 $250.00 $250.00
2/15/2004 KW 12KW2003 $300.00 $500.00 -$200.00
3/15/2004 KW 1KW2004 ???? $123.00 $584.00 -$461.00
4/15/2001 KW 2KW2004 XXXX $223.00 $484.00 -$261.00
1/15/2004 SO 11O2003 $300.00 $250.00 $50.00
2/15/2004 SO 12SO2003 $300.00 $500.00 -$200.00...
|
by: Paul Mendez |
last post by:
I really need your assistance. I tried what you gave me and it did
not work and I am thinking that the formatting that showed up when u
saw my posting might have confused you. So I made sure to align it
correctly this time. Ok... this is what I want it to get done. Where
the X and Y are, I need to have showing is the values, $250.00 and
$216.00, respectively. What it needs to do is... go back two months
from the current date that they...
|
by: Tony |
last post by:
I have a situation where I want to send data, but I have no need for a
response. It seems to me that XMLHTTPRequest is the best way to send the
data, but I don't need any response back from the server.
Basically, I'm writing js errors to an error log on the server side -
and there is no need to inform the user that the error has been logged.
The problem is that I don't want to sit with the request open & waiting
for a response, when I...
|
by: Blarneystone |
last post by:
Hi,
I am using VB.NET and trying to pull data from two different tables in
the database. I am using what I think is standard code. But the data
I am pulling is like the following:
Table1 Column1 Row1
Table2 Column1 Row1 ~ 20
Table1 Column1 Row2 ~ 3
|
by: Michael R |
last post by:
Hi all.
I'm writing a report that utilizes a query called qryRecords
SELECT * FROM tblRecordsORG1;
however, there is tblRecordsORG1, tblRecordsORG2, etc. qryRecords should be based on tblRecordsORG?. My attempt is:
SELECT DISTINCT IIf(Form!MyForm!MyControl=1,.,.) AS Column1, IIf(Form!MyForm!MyControl=1,.,.) AS Column2, IIf(Form!MyForm!MyControl=1,.,.) AS Column3....
FROM tblRecordsORG1, tblRecordsORG2;
this is not enough, because number...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
