473,404 Members | 2,179 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > mysql database > questions > join 3 tables - distinct results

Join Bytes to post your question to a community of 473,404 software developers and data experts.

Join 3 Tables - distinct results

All

I've got a database that keeps track of sales of widgets. Each company
that belongs to my organiztion is to report their widget sales or no
sales every month.

There are several different types of widgets. Not all companies sell or
report all types of widgets.

We want to report how many companies have reported or not reported their
sales (ie. x companies of a possible y companies have reported sales
this month - y will always be the same - lets say 5).

Because of the way that sales are input, "big widgets" are reported in 2
different tables called widgets_a and widgets_b. If they don't have any
sales to report, they still report and it goes into a table called
no_reports. Each table has a couple of common fields - ManufacturerID
and OrderDate.

I can search all of the tables individually to find if a manufacturer
has reported -

SELECT DISTINCT ManufacturerID FROM widgets_a WHERE OrderDate >=
'2003-06-01' AND OrderDate <= '2003-06-30';

but I want to search through the 3 tables and find how many distinct
manufacturers have reported in the given month. I know this can be
accomplished through a join, but I need some help. Thanks in advance.

Dave

Jul 19 '05 #1
9 6100
Can you give the table structures? This looks like an interesting one to
try....

"Dave M" <di******@eswis.net> wrote in message
news:rh************@news.randori.com...
All

I've got a database that keeps track of sales of widgets. Each company
that belongs to my organiztion is to report their widget sales or no
sales every month.

There are several different types of widgets. Not all companies sell or
report all types of widgets.

We want to report how many companies have reported or not reported their
sales (ie. x companies of a possible y companies have reported sales
this month - y will always be the same - lets say 5).

Because of the way that sales are input, "big widgets" are reported in 2
different tables called widgets_a and widgets_b. If they don't have any
sales to report, they still report and it goes into a table called
no_reports. Each table has a couple of common fields - ManufacturerID
and OrderDate.

I can search all of the tables individually to find if a manufacturer
has reported -

SELECT DISTINCT ManufacturerID FROM widgets_a WHERE OrderDate >=
'2003-06-01' AND OrderDate <= '2003-06-30';

but I want to search through the 3 tables and find how many distinct
manufacturers have reported in the given month. I know this can be
accomplished through a join, but I need some help. Thanks in advance.

Dave

Jul 19 '05 #2
Can you give the table structures? This looks like an interesting one to
try....

"Dave M" <di******@eswis.net> wrote in message
news:rh************@news.randori.com...
All

I've got a database that keeps track of sales of widgets. Each company
that belongs to my organiztion is to report their widget sales or no
sales every month.

There are several different types of widgets. Not all companies sell or
report all types of widgets.

We want to report how many companies have reported or not reported their
sales (ie. x companies of a possible y companies have reported sales
this month - y will always be the same - lets say 5).

Because of the way that sales are input, "big widgets" are reported in 2
different tables called widgets_a and widgets_b. If they don't have any
sales to report, they still report and it goes into a table called
no_reports. Each table has a couple of common fields - ManufacturerID
and OrderDate.

I can search all of the tables individually to find if a manufacturer
has reported -

SELECT DISTINCT ManufacturerID FROM widgets_a WHERE OrderDate >=
'2003-06-01' AND OrderDate <= '2003-06-30';

but I want to search through the 3 tables and find how many distinct
manufacturers have reported in the given month. I know this can be
accomplished through a join, but I need some help. Thanks in advance.

Dave

Jul 19 '05 #3
Can you give the table structures? This looks like an interesting one to
try....

"Dave M" <di******@eswis.net> wrote in message
news:rh************@news.randori.com...
All

I've got a database that keeps track of sales of widgets. Each company
that belongs to my organiztion is to report their widget sales or no
sales every month.

There are several different types of widgets. Not all companies sell or
report all types of widgets.

We want to report how many companies have reported or not reported their
sales (ie. x companies of a possible y companies have reported sales
this month - y will always be the same - lets say 5).

Because of the way that sales are input, "big widgets" are reported in 2
different tables called widgets_a and widgets_b. If they don't have any
sales to report, they still report and it goes into a table called
no_reports. Each table has a couple of common fields - ManufacturerID
and OrderDate.

I can search all of the tables individually to find if a manufacturer
has reported -

SELECT DISTINCT ManufacturerID FROM widgets_a WHERE OrderDate >=
'2003-06-01' AND OrderDate <= '2003-06-30';

but I want to search through the 3 tables and find how many distinct
manufacturers have reported in the given month. I know this can be
accomplished through a join, but I need some help. Thanks in advance.

Dave

Jul 19 '05 #4
mysql> desc no_report;
+----------------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+----------------+----------------------+------+-----+---------+----------------+
| NRID | smallint(5) unsigned | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------+----------------------+------+-----+---------+----------------+
etc ...

mysql> desc widgets_a;
+----------------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default |
Extra |
+----------------------------+-------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| NumberUnits | int(11) | YES | | NULL |
|
| ContractNumber | text | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------------------+-------------+------+-----+---------+----------------+
etc ...

mysql> desc widgets_b;
+----------------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default |
Extra |
+----------------------------+-------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| NumberUnits | int(11) | YES | | NULL |
|
| ContractNumber | text | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------------------+-------------+------+-----+---------+----------------+
etc ...

Brandon wrote:
Can you give the table structures? This looks like an interesting one to
try....

"Dave M" <di******@eswis.net> wrote in message
news:rh************@news.randori.com...
All

I've got a database that keeps track of sales of widgets. Each company
that belongs to my organiztion is to report their widget sales or no
sales every month.

There are several different types of widgets. Not all companies sell or
report all types of widgets.

We want to report how many companies have reported or not reported their
sales (ie. x companies of a possible y companies have reported sales
this month - y will always be the same - lets say 5).

Because of the way that sales are input, "big widgets" are reported in 2
different tables called widgets_a and widgets_b. If they don't have any
sales to report, they still report and it goes into a table called
no_reports. Each table has a couple of common fields - ManufacturerID
and OrderDate.

I can search all of the tables individually to find if a manufacturer
has reported -

SELECT DISTINCT ManufacturerID FROM widgets_a WHERE OrderDate >=
'2003-06-01' AND OrderDate <= '2003-06-30';

but I want to search through the 3 tables and find how many distinct
manufacturers have reported in the given month. I know this can be
accomplished through a join, but I need some help. Thanks in advance.

Dave



Jul 19 '05 #5
mysql> desc no_report;
+----------------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+----------------+----------------------+------+-----+---------+----------------+
| NRID | smallint(5) unsigned | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------+----------------------+------+-----+---------+----------------+
etc ...

mysql> desc widgets_a;
+----------------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default |
Extra |
+----------------------------+-------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| NumberUnits | int(11) | YES | | NULL |
|
| ContractNumber | text | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------------------+-------------+------+-----+---------+----------------+
etc ...

mysql> desc widgets_b;
+----------------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default |
Extra |
+----------------------------+-------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| NumberUnits | int(11) | YES | | NULL |
|
| ContractNumber | text | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------------------+-------------+------+-----+---------+----------------+
etc ...

Brandon wrote:
Can you give the table structures? This looks like an interesting one to
try....

"Dave M" <di******@eswis.net> wrote in message
news:rh************@news.randori.com...
All

I've got a database that keeps track of sales of widgets. Each company
that belongs to my organiztion is to report their widget sales or no
sales every month.

There are several different types of widgets. Not all companies sell or
report all types of widgets.

We want to report how many companies have reported or not reported their
sales (ie. x companies of a possible y companies have reported sales
this month - y will always be the same - lets say 5).

Because of the way that sales are input, "big widgets" are reported in 2
different tables called widgets_a and widgets_b. If they don't have any
sales to report, they still report and it goes into a table called
no_reports. Each table has a couple of common fields - ManufacturerID
and OrderDate.

I can search all of the tables individually to find if a manufacturer
has reported -

SELECT DISTINCT ManufacturerID FROM widgets_a WHERE OrderDate >=
'2003-06-01' AND OrderDate <= '2003-06-30';

but I want to search through the 3 tables and find how many distinct
manufacturers have reported in the given month. I know this can be
accomplished through a join, but I need some help. Thanks in advance.

Dave



Jul 19 '05 #6
mysql> desc no_report;
+----------------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+----------------+----------------------+------+-----+---------+----------------+
| NRID | smallint(5) unsigned | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------+----------------------+------+-----+---------+----------------+
etc ...

mysql> desc widgets_a;
+----------------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default |
Extra |
+----------------------------+-------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| NumberUnits | int(11) | YES | | NULL |
|
| ContractNumber | text | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------------------+-------------+------+-----+---------+----------------+
etc ...

mysql> desc widgets_b;
+----------------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default |
Extra |
+----------------------------+-------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| NumberUnits | int(11) | YES | | NULL |
|
| ContractNumber | text | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------------------+-------------+------+-----+---------+----------------+
etc ...

Brandon wrote:
Can you give the table structures? This looks like an interesting one to
try....

"Dave M" <di******@eswis.net> wrote in message
news:rh************@news.randori.com...
All

I've got a database that keeps track of sales of widgets. Each company
that belongs to my organiztion is to report their widget sales or no
sales every month.

There are several different types of widgets. Not all companies sell or
report all types of widgets.

We want to report how many companies have reported or not reported their
sales (ie. x companies of a possible y companies have reported sales
this month - y will always be the same - lets say 5).

Because of the way that sales are input, "big widgets" are reported in 2
different tables called widgets_a and widgets_b. If they don't have any
sales to report, they still report and it goes into a table called
no_reports. Each table has a couple of common fields - ManufacturerID
and OrderDate.

I can search all of the tables individually to find if a manufacturer
has reported -

SELECT DISTINCT ManufacturerID FROM widgets_a WHERE OrderDate >=
'2003-06-01' AND OrderDate <= '2003-06-30';

but I want to search through the 3 tables and find how many distinct
manufacturers have reported in the given month. I know this can be
accomplished through a join, but I need some help. Thanks in advance.

Dave



Jul 19 '05 #7
I am going to assume you have a lookup table for the Manufacturer. I'm using
this common table to do the joins from. I also assumed that it will be more
helpfull to see the companyname rather than the ID, if not just change the
select. I created a forth table to test this called manid which has two
fields ID and companyname.

SELECT DISTINCT manid.companyname
FROM manid LEFT JOIN no_report ON manid.id = no_report.manufacturerid
LEFT JOIN widgets_a ON manid.id = widgets_a.manufacturerid
LEFT JOIN widgets_b on manid.id = widgets_b.manufacturerid
WHERE (no_report.orderdate >='2003-08-01' AND no_report.orderdate
<='2003-08-31') OR
(widgets_a.orderdate >='2003-08-01' AND widgets_a.orderdate <='2003-08-31')
OR
(widgets_b.orderdate >='2003-08-01' and widgets_b.orderdate <='2003-08-31')

Let me know if this produces the desired results.

Brandon

"Dave M" <di******@eswis.net> wrote in message
news:bs***********@news.randori.com...
mysql> desc no_report;
+----------------+----------------------+------+-----+---------+------------
----+ | Field | Type | Null | Key | Default | Extra
|
+----------------+----------------------+------+-----+---------+------------
----+ | NRID | smallint(5) unsigned | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------+----------------------+------+-----+---------+------------
----+ etc ...

mysql> desc widgets_a;
+----------------------------+-------------+------+-----+---------+---------
-------+ | Field | Type | Null | Key | Default |
Extra |
+----------------------------+-------------+------+-----+---------+---------
-------+ | id | int(11) | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| NumberUnits | int(11) | YES | | NULL |
|
| ContractNumber | text | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------------------+-------------+------+-----+---------+---------
-------+ etc ...

mysql> desc widgets_b;
+----------------------------+-------------+------+-----+---------+---------
-------+ | Field | Type | Null | Key | Default |
Extra |
+----------------------------+-------------+------+-----+---------+---------
-------+ | id | int(11) | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| NumberUnits | int(11) | YES | | NULL |
|
| ContractNumber | text | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------------------+-------------+------+-----+---------+---------
-------+ etc ...

Brandon wrote:
Can you give the table structures? This looks like an interesting one to try....

"Dave M" <di******@eswis.net> wrote in message
news:rh************@news.randori.com...
All

I've got a database that keeps track of sales of widgets. Each company
that belongs to my organiztion is to report their widget sales or no
sales every month.

There are several different types of widgets. Not all companies sell or
report all types of widgets.

We want to report how many companies have reported or not reported their
sales (ie. x companies of a possible y companies have reported sales
this month - y will always be the same - lets say 5).

Because of the way that sales are input, "big widgets" are reported in 2
different tables called widgets_a and widgets_b. If they don't have any
sales to report, they still report and it goes into a table called
no_reports. Each table has a couple of common fields - ManufacturerID
and OrderDate.

I can search all of the tables individually to find if a manufacturer
has reported -

SELECT DISTINCT ManufacturerID FROM widgets_a WHERE OrderDate >=
'2003-06-01' AND OrderDate <= '2003-06-30';

but I want to search through the 3 tables and find how many distinct
manufacturers have reported in the given month. I know this can be
accomplished through a join, but I need some help. Thanks in advance.

Dave


Jul 19 '05 #8
I am going to assume you have a lookup table for the Manufacturer. I'm using
this common table to do the joins from. I also assumed that it will be more
helpfull to see the companyname rather than the ID, if not just change the
select. I created a forth table to test this called manid which has two
fields ID and companyname.

SELECT DISTINCT manid.companyname
FROM manid LEFT JOIN no_report ON manid.id = no_report.manufacturerid
LEFT JOIN widgets_a ON manid.id = widgets_a.manufacturerid
LEFT JOIN widgets_b on manid.id = widgets_b.manufacturerid
WHERE (no_report.orderdate >='2003-08-01' AND no_report.orderdate
<='2003-08-31') OR
(widgets_a.orderdate >='2003-08-01' AND widgets_a.orderdate <='2003-08-31')
OR
(widgets_b.orderdate >='2003-08-01' and widgets_b.orderdate <='2003-08-31')

Let me know if this produces the desired results.

Brandon

"Dave M" <di******@eswis.net> wrote in message
news:bs***********@news.randori.com...
mysql> desc no_report;
+----------------+----------------------+------+-----+---------+------------
----+ | Field | Type | Null | Key | Default | Extra
|
+----------------+----------------------+------+-----+---------+------------
----+ | NRID | smallint(5) unsigned | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------+----------------------+------+-----+---------+------------
----+ etc ...

mysql> desc widgets_a;
+----------------------------+-------------+------+-----+---------+---------
-------+ | Field | Type | Null | Key | Default |
Extra |
+----------------------------+-------------+------+-----+---------+---------
-------+ | id | int(11) | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| NumberUnits | int(11) | YES | | NULL |
|
| ContractNumber | text | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------------------+-------------+------+-----+---------+---------
-------+ etc ...

mysql> desc widgets_b;
+----------------------------+-------------+------+-----+---------+---------
-------+ | Field | Type | Null | Key | Default |
Extra |
+----------------------------+-------------+------+-----+---------+---------
-------+ | id | int(11) | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| NumberUnits | int(11) | YES | | NULL |
|
| ContractNumber | text | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------------------+-------------+------+-----+---------+---------
-------+ etc ...

Brandon wrote:
Can you give the table structures? This looks like an interesting one to try....

"Dave M" <di******@eswis.net> wrote in message
news:rh************@news.randori.com...
All

I've got a database that keeps track of sales of widgets. Each company
that belongs to my organiztion is to report their widget sales or no
sales every month.

There are several different types of widgets. Not all companies sell or
report all types of widgets.

We want to report how many companies have reported or not reported their
sales (ie. x companies of a possible y companies have reported sales
this month - y will always be the same - lets say 5).

Because of the way that sales are input, "big widgets" are reported in 2
different tables called widgets_a and widgets_b. If they don't have any
sales to report, they still report and it goes into a table called
no_reports. Each table has a couple of common fields - ManufacturerID
and OrderDate.

I can search all of the tables individually to find if a manufacturer
has reported -

SELECT DISTINCT ManufacturerID FROM widgets_a WHERE OrderDate >=
'2003-06-01' AND OrderDate <= '2003-06-30';

but I want to search through the 3 tables and find how many distinct
manufacturers have reported in the given month. I know this can be
accomplished through a join, but I need some help. Thanks in advance.

Dave


Jul 19 '05 #9
I am going to assume you have a lookup table for the Manufacturer. I'm using
this common table to do the joins from. I also assumed that it will be more
helpfull to see the companyname rather than the ID, if not just change the
select. I created a forth table to test this called manid which has two
fields ID and companyname.

SELECT DISTINCT manid.companyname
FROM manid LEFT JOIN no_report ON manid.id = no_report.manufacturerid
LEFT JOIN widgets_a ON manid.id = widgets_a.manufacturerid
LEFT JOIN widgets_b on manid.id = widgets_b.manufacturerid
WHERE (no_report.orderdate >='2003-08-01' AND no_report.orderdate
<='2003-08-31') OR
(widgets_a.orderdate >='2003-08-01' AND widgets_a.orderdate <='2003-08-31')
OR
(widgets_b.orderdate >='2003-08-01' and widgets_b.orderdate <='2003-08-31')

Let me know if this produces the desired results.

Brandon

"Dave M" <di******@eswis.net> wrote in message
news:bs***********@news.randori.com...
mysql> desc no_report;
+----------------+----------------------+------+-----+---------+------------
----+ | Field | Type | Null | Key | Default | Extra
|
+----------------+----------------------+------+-----+---------+------------
----+ | NRID | smallint(5) unsigned | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------+----------------------+------+-----+---------+------------
----+ etc ...

mysql> desc widgets_a;
+----------------------------+-------------+------+-----+---------+---------
-------+ | Field | Type | Null | Key | Default |
Extra |
+----------------------------+-------------+------+-----+---------+---------
-------+ | id | int(11) | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| NumberUnits | int(11) | YES | | NULL |
|
| ContractNumber | text | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------------------+-------------+------+-----+---------+---------
-------+ etc ...

mysql> desc widgets_b;
+----------------------------+-------------+------+-----+---------+---------
-------+ | Field | Type | Null | Key | Default |
Extra |
+----------------------------+-------------+------+-----+---------+---------
-------+ | id | int(11) | | PRI | NULL |
auto_increment |
| Date | date | YES | | NULL |
|
| ManufacturerID | smallint(6) | YES | | NULL |
|
| NumberUnits | int(11) | YES | | NULL |
|
| ContractNumber | text | YES | | NULL |
|
| OrderDate | date | YES | | NULL |
|
+----------------------------+-------------+------+-----+---------+---------
-------+ etc ...

Brandon wrote:
Can you give the table structures? This looks like an interesting one to try....

"Dave M" <di******@eswis.net> wrote in message
news:rh************@news.randori.com...
All

I've got a database that keeps track of sales of widgets. Each company
that belongs to my organiztion is to report their widget sales or no
sales every month.

There are several different types of widgets. Not all companies sell or
report all types of widgets.

We want to report how many companies have reported or not reported their
sales (ie. x companies of a possible y companies have reported sales
this month - y will always be the same - lets say 5).

Because of the way that sales are input, "big widgets" are reported in 2
different tables called widgets_a and widgets_b. If they don't have any
sales to report, they still report and it goes into a table called
no_reports. Each table has a couple of common fields - ManufacturerID
and OrderDate.

I can search all of the tables individually to find if a manufacturer
has reported -

SELECT DISTINCT ManufacturerID FROM widgets_a WHERE OrderDate >=
'2003-06-01' AND OrderDate <= '2003-06-30';

but I want to search through the 3 tables and find how many distinct
manufacturers have reported in the given month. I know this can be
accomplished through a join, but I need some help. Thanks in advance.

Dave


Jul 19 '05 #10
New Post

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
Join 3 Tables - distinct results
by: Dave M | last post by:
All I've got a database that keeps track of sales of widgets. Each company that belongs to my organiztion is to report their widget sales or no sales every month. There are several different...
MySQL Database
3
Inner Join / Indexes Hell
by: Ike | last post by:
Oh I have a nasty query which runs incredibly slowly. I am running MySQL 4.0.20-standard. Thus, in trying to expedite the query, I am trying to set indexes in my tables. My query requires four...
MySQL Database
4
SQL - join hassle?
by: Jenni | last post by:
Hi all, Sorry to hassle you with this query, I'm sure the answer is a simple one, but it remains elusive - to me anyway. What I am trying to do is get a query to work. I have a table of people...
Microsoft Access / VBA
7
#Deleted displaying for ODBC linked tables
by: Joe | last post by:
I am using Access 2003 and are linking to an Oracle 9i ODBC datasource (using Oracle ODBC drivers). After linking the tables in Access, I inspect the data contained in the linked tables. For...
Microsoft Access / VBA
5
Migrate Sybase outer join query to UDB DB2 8.2
by: kumar_rangan1976 | last post by:
I need the below sybase code to be migrated in UDB : select distinct c.partnumber as I_PART, case when d.IntegratorID = 'DCX05' then 'U' when d.IntegratorID = 'DCX04' then 'M'...
DB2 Database
52
Can inner join replace multiple loop selects?
by: MP | last post by:
Hi trying to begin to learn database using vb6, ado/adox, mdb format, sql (not using access...just mdb format via ado) i need to group the values of multiple fields - get their possible...
Microsoft Access / VBA
1
getting two distinct fields from one tbl from a join query of two tables
by: mcyi2mr3 | last post by:
Hi Help! Im stuck on a join query. Im trying to get distinct (the same row returned only once) user_id and forename from a tbl of users (they are always distinct) where user_id in that tbl...
MySQL Database
18
INNER JOIN/Index Threshold?
by: Dave | last post by:
Guys I am really stuck on this one. Any help or suggestions would be appreciated. We have a large table which seemed to just hit some kind of threshold. They query is somewhat responsive when...
Microsoft SQL Server
1
complex tables - want to join to get one row of results from multiple rows
by: Vivienne | last post by:
Hi there This is a hard problem that I have - I have only been using sql for a couple of weeks and have gone past my ability level quickly! The real tables are complex but I will post a simple...
Microsoft SQL Server
0
How to turn on java script in a villaon keypad mobile phone
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
Java
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
1
Is that possible of reading the .csv file in column wise and the column have different lengths ?
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
C / C++
0
How to build RAID in BIOS?
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
Computer Hardware
0
marktang
What is ONU?
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,...
General
0
Oralloy
Problem With Comparison Operator <=> in G++
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,...
C / C++
0
The easy way to turn off automatic updates for Windows 10/11
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
Windows Server
0
tracyyun
Discussion: How does Zigbee compare with other wireless protocols in smart home applications?
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...
General
0
isladogs
Access Europe - Using VBA to create a class based on a table - Wed 1 May
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
Microsoft Access / VBA

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!