Hi,
I am new to this list so I apologise if this is not the place to post this
message.
I am in the final stages of completing a project and I have one query that
is causing problems.
I need the query to get a story or stories from the story table and
journalists from the journalist table
I'm pretty sure that I have two queries that could be combined
into one query using a JOIN, but I can not figure out how to do
it. Basically, I need all the rows from TABLE1 that are either
NOT in TABLE2 or IN TABLE2 BUT have been marked as voted by a
user id. Yes, that makes no sense, I'll try
Hi all,
I have three tables:
partners (id,name,url,desc)
services (id,desc,category)
partner_service_rel (pid,sid)
Each partner offers a range of services, and each services has an id,
description, and category.
Now, it's EASY to search for partners that offer a certain service, but I
can't
because there isn't any partners table in the FROM
clause!
--- Justin French [EMAIL PROTECTED] ha scritto:
Hi all,
I have three tables:
partners (id,name,url,desc)
services (id,desc,category)
partner_service_rel (pid,sid)
Each partner offers a range of services, and each
services
Hello All,
Great list !
MySQL = Incredible Product !
I've been trying to come up with a SQL query to perform the following...
Table - Contact
ClientID
Activity1
Activity2
Activity3
Activity4
Time1
Time2
Time3
Time4
Date
I need to get a total of all the activities and their associated time
I've been trying to work out a complicated query to select and
sum multiple columns in one select using a condition and multi column group by
What I expected to get was ONE row with the columns summed .
this query returns 5 rows
SELECT
* TimeWalker
I've been trying to work out a complicated query to select and
sum multiple columns in one select using a condition and multi
column group by
What I expected to get was ONE row with the columns summed .
this query returns 5 rows
SELECT
Jeff,
Try a JOIN:
http://www.mysql.com/doc/en/JOIN.html
or for some good articles:
http://www.onlamp.com/pub/ct/19
HTH!
Cory
On Fri, 2002-11-01 at 10:01, jeff wrote:
Hello
I am having some trouble writing a query that will pull the information I
need from the database. I hope it's
-Original Message-
From: Chris Mason [mailto:masonc;masonc.com]
[...]
The problem is, it is easy to test for one amenity, but I need to test
that the hotel has all of the amenities. The query above
returns all the
hotels that have ANY of the amenities, I need the hotels having ALL
://www.clementezamora.com)
Chris Mason [EMAIL PROTECTED] wrote:
Asunto: Need a little query help
Fecha: Mon, 28 Oct 2002 08:08:41 -0400
De: Chris Mason [EMAIL PROTECTED]
A: [EMAIL PROTECTED]
I am trying to select some data from a hotel database I am putting on
the web. Currently I am using two
I am trying to select some data from a hotel database I am putting on
the web. Currently I am using two temporary tables and three queries to
get the data, but I suspect it can be done in one query by a better
knowledge of SQL.
The tables are
Hotels:
ID,
PostCode,
ShowHotel
AmenityLink:
ID,
, October 26, 2002 6:43 AM
To: Franklin Williams Jr.; [EMAIL PROTECTED]
Subject: Re: self relation query help
Franklin, the basic relational rules
(http://hometown.aol.com/mbaddenda/art120.html,
http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter7/node1.html) say,
decompose relationships like your
This is probably going more into db design than pure mysql issues...on
the other hand if performance is at stake with these different
designs.
After several inputs - which I am EXTREMELY thankful for - here are
some of my thoughts. The solution using Joseph's table aliases works
beautifully.
I have a table with names in it where the names can function as 1 of 2 things -
either an artist or a group. In order to make searching easy I wished to keep
these names in one table. EG: searching for artist name, whether a group or
soloist you would have to search only one table. The problem
-
From: Franklin Williams Jr. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 25, 2002 9:44 PM
Subject: self relation query help
I have a table with names in it where the names can function as 1 of 2
things -
either an artist or a group. In order to make searching easy I wished
Franklin Williams Jr. wrote:
I have a table with names in it where the names can function as 1 of 2
things -
either an artist or a group. In order to make searching easy I wished
to keep
these names in one table. EG: searching for artist name, whether a
group or
soloist you would have to
Hello,
I have the following table structure and need assistance on a mysql query:
Members
MemberID (unique)
Name
Address
Credits
CreditID
MemberID
Project
Title
Credit_Images
=
ImageID
CreditID
Location
Comments
Showroom
=
ShowroomID
MemberID
Size
Comments
Maybe I'm way out here, but this happens to me (or similar) quite often.
My solution; SELECT DISTINCT
And a single row will be returned for each.
Niclas
On Tuesday 08 October 2002 21:48, Michael Knauf/Niles wrote:
Here's a query for ya:
SELECT products.product_name, products.fg_number,
Here's a query for ya:
SELECT products.product_name, products.fg_number,
products.product_description, specs.spec_name, specs.spec_value FROM
products LEFT JOIN specs ON products.fg_number = specs.fg_number WHERE
products.fg_number='fg00914';
and here's the result:
Michael Knauf/Niles wrote:
I get 7 rows of data I don't want, then the 7 rows of data I do want... and
after scratching my head for awhile, I've come to the conclusion that I do
not understand the query structure. (the query came from multiple
suggestions in response to my last posting on this
Subject: Re: query help
10/08/02 11:40 AM
Michael Knauf/Niles wrote:
What I _really_ want is the combination of your two querys, that is,
product_name, product_description, from the product table + all the specs
related to the product from the specs table , based on the fg00914 number.
Are you sure? :-)
As I pointed out, if the first
: [EMAIL PROTECTED]
Asunto: query help
Here's a query for ya:
SELECT products.product_name, products.fg_number,
products.product_description, specs.spec_name,
specs.spec_value FROM products LEFT JOIN specs ON
products.fg_number = specs.fg_number WHERE
products.fg_number='fg00914
Subject: Re: query help
10/08/02 12:08 PM
keep looking for the books and help, but there's
another resource for you while you're learning, and
it's free.
if you have a windows machine that you can use as a
front end to your mysql server (or any other
database), go to http://corereader.com/ .
after you connect to your database,
Can someone please help me with the following? Normally I would do this
with a nested select, but since this is not available in MySQL I think I
need help.
Here is what I have: An order table with sales tax total and an
orderdetail table with ordered, itemid and qty.
What I need to do is form
David McInnis wrote:
select tax from orders, orderdetail where orders.id =
orderdetail.orderid and (productid = 1 or productid = 2 or productid =
3)
I can get multiple tax amounts where an order has multiple matching
records in orderdetail. I know that I can group by order.id, but what I
)
| grp_id | varchar(10)
| grp_pwd| varchar(10)
++---
-Original Message-
From: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 1:00 PM
To: '[EMAIL PROTECTED]'
Subject: Re: Query
So you want a SQL QUERY something like:
SELECT ORDERDETAIL.id as detailid, qty, unitcost, unitcost * qty as
extended from ORDERDETAIL
LEFT JOIN ORDERS ON orderid = ORDERS.id
WHERE ...
Right?
What's the problem you have with tax requests that you hinted at last time?
David McInnis
[mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 2:19 PM
To: David McInnis
Cc: [EMAIL PROTECTED]
Subject: Re: Query help
So you want something like:
SELECT ORDERDETAIL.id as detailid, qty, unitcost, unitcost * qty as
extended from ORDERDETAIL
LEFT JOIN ORDERS ON orderid = ORDERS.id
On Fri, Oct 04, 2002 at 12:36:30PM -0700, David McInnis wrote:
Can someone please help me with the following? Normally I would do this
with a nested select, but since this is not available in MySQL I think I
need help.
Here is what I have: An order table with sales tax total and an
filter fodder: sql, query
Hi all,
I feel like I am probly being amazingly stupid, but here goes nothing.
I have 3 tables:
students
undergrads
postgrads
students holds all common info. eg dt_matric, dob, religion, etc.
undergrads hold eg. degree, subject
postgrads holds eg. transfer_date,
Hi Craig,
you wrote---
select B.name,C.name
from lookuptable A, user B, cat C
where A.user = B.id
and A.category = C.id
and A.category in (3,5);
The problem I see is that records come back where a user is in category
3 or
category 5. How do I limit records
I know this is an off topic question, but wondered if anyone might have a
moment to help. I wouldn't ask if I could do a sub-select...
I am using mysql v3.23.51 and have a table I need to display the information
of users who are working in both category 3 and category 5.
Table def looks kind
Greetings:
RE: mySQL query help please
INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID,
Configuration, Equipment_Type, Group_ID, Location, Rack_Location,
Network_Status_Name, Creator_ID, Primary_IP_Address FROM
Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4
[snip]
INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID,
Configuration, Equipment_Type, Group_ID, Location, Rack_Location,
Network_Status_Name, Creator_ID, Primary_IP_Address FROM
Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4) =
Customer.User_ID;
The select statement
Greetings Jay:
RE: mySQL query help please
I love rules that don't make sense ;-)
So if the end result is to have the records selected appended to the
Customer_Equipment table, I have to make a temporary table based on the
characteristics of the Customer_Equipment table... then insert from
[snip]
So if the end result is to have the records selected appended to the
Customer_Equipment table, I have to make a temporary table based on the
characteristics of the Customer_Equipment table... then insert from that
temporary table. Correct?
[/snip]
BINGO! Goofy rules can be frustrating
Hi Chris,
On Fri, 2002-06-14 at 02:08, Chris Kay wrote:
I have a rather longer query which I would like to get all records past todays date.
Here is my query
$ttwo = date(YmdGi);
snip
I have a rather longer query which I would like to get all records past todays date.
Here is my query
$ttwo = date(YmdGi);
$abc =
select
detail.*,
type.type_name,
status.status_name,
staff.staff_name,
I need some help... The query below runs
fine in access, when running it in mysql it tells me the column wrainfo.wuc
doesn't exist in the having clause.. can't figure out why its giving me this
error. the column is in the select statement... any ideas? The column does
exist.. I'm looking at
PROTECTED]]
Sent: Thursday, June 06, 2002 7:23 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: mysql query help
I need some help... The query below runs
fine in access, when running it in mysql it tells me the column wrainfo.wuc
doesn't exist in the having clause.. can't figure out why
]
To: Scott Raley/LPEC/ASD/SEMCORINC@SEMCOR INC., [EMAIL PROTECTED],
[EMAIL PROTECTED]
cc:
Subject: RE: mysql query help
I've not looked over your query in-depth so I may be off-base here. Try
removing the parentheses from the FROM clause and see if that makes it work.
=C=
*
* Cal
First off, I would like to thank everyone on this lists who helps people
like myself!
I'm having trouble with the following query:
SELECT username, first_name, email, DATE_FORMAT(signup_date, '%b %e,
%Y') AS signup_date FROM members WHERE referer = (id)
It selects a list of all members from the
I probably did not provide enough info the first time. The members table
is setup as follows:
Id (primary key)
Referer (relates to the primary key of the table)
I am given a member ID, say 4. I need to display all members who have
been referred by member 4 (obviously no problem). However, for
Hi.
On Wed 2002-06-05 at 13:37:22 -0500, [EMAIL PROTECTED] wrote:
[...]
It selects a list of all members from the database referred by a certain
member. However, the query needs to be modified to also select the
number of people that person has referred. I planned to just send
another query
As a follow up to my previous question, two possible solutions came to
mind:
1) Query members table for all members matching criteria stored in that
table (country, marital status, income, etc). Then, take all those
member_ids, and query member_interests table for members who match
there. i.e.,
I've been trying to solve this problem for a couple of days now.
I've only started with DB's a month ago so I am no expert in SQL.
So, I present this problem to you guys in hopes of getting a solution.
Thanks in advance,
Mike
=
Question:
=
Using the query below I get the result
OK, I cannot find this sql query on the website or in any of my manuals.
I have a table that contains a set datatype eg
CREATE TABLE testjason (
ID int(11) NOT NULL auto_increment,
SomeSetColumn set('a','b','c') NOT NULL default '',
) TYPE=MyISAM;
I neet to perform an UPDATE on this
sql,query
I have a table with the following structure:
CREATE TABLE cartconfig_module (
UserID int(10) unsigned NOT NULL default '0',
GroupID int(10) unsigned NOT NULL default '0',
SiteID int(10) unsigned NOT NULL default '0',
Perms enum('Modify','View','Deny') NOT NULL default 'View',
I can't seem to properly wrap my brain around left joins. If anyone
knows of a good tutorial somewhere, I'd appreciate it. That having been
said, I was hoping someone could help with this query I'm trying to do
as I've been horribly unsuccessful.
3 tables: goal (own goals), goalopp (opponent
, 2002 1:38 PM
Subject: Query help
I can't seem to properly wrap my brain around left joins. If anyone
knows of a good tutorial somewhere, I'd appreciate it. That having been
said, I was hoping someone could help with this query I'm trying to do
as I've been horribly unsuccessful.
3 tables
Hello everyone
I want to alter 50 tables, and for each the names start with the string
'mak'
Is there an SQL query, so that I can do the change in one command.
I have tried using wildcards - they don't seem to work in SQL.
Thanks in advance.
Aman
SELECT * FROM mytable WHERE first_name=$first last_name=$last
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 10:28 AM
To: [EMAIL PROTECTED]
Subject: Query help
Hi. I have two fields, firstname, lastname. I populate a select box
can even store an
alternate value (that being the id) already
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 12:21 PM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: Query help
This will not work for my example. I have a select box
[EMAIL PROTECTED] wrote:
This will not work for my example. I have a select box that was populated
from the db with firstname lastname. The option tag has the value of
firstname+lastname then. Here lies the problem, when I build the query, I
have no way of distinguishing firstname and
first_name=$first last_name=$last
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 10:28 AM
To: [EMAIL PROTECTED]
Subject: Query help
Hi. I have two fields, firstname, lastname. I populate a select box
with
the firstname
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 3:47 PM
To: Danis Stéphane (NHQ-AC); [EMAIL PROTECTED]
Subject: Re: SQL Query Help
Stéphane,
I have INVOICE table here is the layout:
+-+---+--+-+-+--
--+
| Field
From: Danis Stéphane (NHQ-AC) [EMAIL PROTECTED]
My best code is this:
SELECT SUM(invoice_amount), state, statement_date
FROM invoice
GROUP BY state, statement_date
The results are have followed:
snip
The main problem is the layout and the order of the results set. I will
have
9 state
Stéphane,
Answers:
There are nine different states (and there are 12 months).
*
The main problem is the layout and the order of the results set. I will
have
9 state (provinces) and I would prefer the month to be the columns. The
ideal results would look like this, Please note I have only
PROTECTED]
Subject: Re: SQL Query Help
Stéphane,
Have just re-read my response...
*
The main problem is the layout and the order of the results set. I will
have
9 state (provinces) and I would prefer the month to be the columns. The
ideal results would look like this, Please note I have only
I have INVOICE table here is the layout:
+-+---+--+-+-+--
--+
| Field | Type | Null | Key | Default | Extra
|
+-+---+--+-+-+--
--+
| ID
Stéphane,
I have INVOICE table here is the layout:
+-+---+--+-+-+--
--+
| Field | Type | Null | Key | Default |
Extra
|
+-+---+--+-+-+--
- Original Message -
From: [EMAIL PROTECTED]
To: Chuck Barnett [EMAIL PROTECTED]
Sent: Tuesday, March 26, 2002 2:09 PM
Subject: Re: query help
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
[For the spam-bot: Go away, you annoying little beast. You know I'm not
posting spam so stop querying me about it and let's get back to the topic at
hand; sql]
On Sunday 03 February 2002 1:27 pm, Chuck Barnett wrote:
Hi, I have a db field that holds the first and last name of a person. Is
* John Hughes
I have three tables:
students has student_id and student_name
parents has parent_id and parent_name
parentlog has student_id and parent_id
I want to search the parentlog WHERE student_id = some_id
GROUP BY parent_id
(This will bring back two rows when there are two
SQL QUERY question
I have three tables:
students has student_id and student_name
parents has parent_id and parent_name
parentlog has student_id and parent_id
I want to search the parentlog WHERE student_id = some_id
GROUP BY parent_id
(This will bring back two rows when there are two
I need help writing query that would give me parent categories of catID from
categories table.
For example, if catID=030 then it should give me:
Birthday | Special Birthday | Special Birthday
If catID=028
Birthday | General Birthday | NULL
desc categories
Do you have another table with all the birthdates in it?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:05 PM
To: [EMAIL PROTECTED]
Subject: Query help please!
I need help writing query that would give me parent categories
One more thing... What are you using to pull the data? PHP? Perl?
Etc?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:05 PM
To: [EMAIL PROTECTED]
Subject: Query help please!
I need help writing query that would give me parent
Hi,
I've got item table as follwoing:
itemno|item_name
1 item one
2 item two
3 item three
4 item four
2 item two
3 item three
I want to right a query so I get three rows of each item I specify in WHERE
for example
SELECT itemname from
Hi Pinkesh,
I've got item table as follwoing:
itemno|item_name
1 item one
2 item two
3 item three
4 item four
2 item two
3 item three
I want to right a query so I get three rows of each item I specify in WHERE
for example
Hello I have a query that goes through and gets the
data out of three tables without a problems. Now the
task at hand is to compair that out put against three
identiacal tables not displaying any duplicate date.
Tables:
a
a.aocode , a.CaseNo , a.CaseName
b.
b.ao_code , b.initials
c
On Wednesday 20 February 2002 09:20, Web boy wrote:
You want to use UNION. If I remember correctly its a fairly new feature for
MySQL, but its a standard SQL thing. From the manual:
SELECT ...
UNION [ALL]
SELECT ...
[UNION
SELECT ...]
UNION is implemented in MySQL 4.0.0.
UNION is used
Is there another way as I do not have that version of
MYSQL installed on my server?
THanks-
KCK
--- Tod Harter [EMAIL PROTECTED] wrote:
On Wednesday 20 February 2002 09:20, Web boy wrote:
You want to use UNION. If I remember correctly its a
fairly new feature for
MySQL, but its a standard
I am trying to run a query I have a table Records
|Record_ID|
|Phase_ID |
|Record_Date|
I need to find the records that have a record date between date1 and
date 2 but exclude the records with
Query help
I am trying to run a query I have a table Records
|Record_ID|
|Phase_ID |
|Record_Date|
I need to find the records that have a record date between date1 and
date 2 but exclude
Query help
I am trying to run a query I have a table Records
|Record_ID|
|Phase_ID |
|Record_Date|
I need to find the records that have a record date between date1 and
date 2 but exclude
Query help
I am trying to run a query I have a table Records
|Record_ID|
|Phase_ID |
|Record_Date|
I need to find the records that have a record date between date1 and
date 2 but exclude
into the selection of record 2?
-Original Message-
From: John Rosendahl [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 12:53 PM
To: [EMAIL PROTECTED]
Subject: Exclusion Query help
I am trying to run a query I have a table Records
|Record_ID
you.
Thanks,
Rama Raju
-Original Message-
From: udayashankarl_n [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 9:38 AM
To: Etienne; [EMAIL PROTECTED]
Subject: RE: Join Query Help
Hi,
The below mentioned query,
select eventartists.eaDnID,djnames.dnName,eventartists.eaDn2ID
Hello,
I'm back to the list after two weeks off.
I have a little problem, the email may seem long but it's clearly explained
step by step what I've done...
I have a table that have artists playing at events. It's called
eventartists. One artist can play alone, or with another artist. Because
: Etienne [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 9:14 AM
To: [EMAIL PROTECTED]
Subject: Join Query Help
Hello,
I'm back to the list after two weeks off.
I have a little problem, the email may seem long but it's clearly
explained
step by step what I've done...
I have a table that have
I need to replace some data with data from a backup. Here's the scenerio...
I have 2 databases. a and abak
a and abak are the same (but, ones a few hours old with the right data ;) )
a and abak have a table, posts and a field 'attach'. I'd like to take
the data from abak.posts.attach and
I have two tables, one for the articles and one with orderrows. When I update the
price in the article table i want to make a query to update the price in orderrows on
all rows with a certain orderstatus.
I can't figure out how to write this query...
I tried
UPDATE orderrows SET price =
Mattias Persson writes:
I have two tables, one for the articles and one with orderrows. When I update the
price in the article table i want to make a query to update the price in orderrows on
all rows with a certain orderstatus.
Can anyone please help me!!!
From the manual:
[...] new
Hy,
I have a question on how to build a query.
scenario:
I have three tables,
Users:
--
user_id INT(32),
username CHAR(64)
Tasks:
--
task_id(INT32),
task_name CHAR(64)
Authorization:
--
user_id INT(32),
task_id INT(32)
some details of database design are neclected
* Henning Sprang
Now I want to create a query to get all task_id's which one given User
isn't already assigned to. I tried a lot of things, Joined in every
direction and so but do not come to my result.
The problem in this situation is that you want to join with records that are
not there. I
It's not the IN, it's the sub-query you cannot use. MySQL doesn't support
them and it's just about the main reason I don't like it.
Alternatives? You could execute your subquery and return the results to an
array. Loop through the array, using the index and the indexed element to
drive a
I dont think we can use 'IN' and 'NOT IN' in mysql. Is there an alternative
that would work?
select * from lib_asset_tbl where material_id '' and asset_id in (select
asset_id from lib_copy_tbl)
Help is appreciated.
Regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc.
Harpreet writes:
I dont think we can use 'IN' and 'NOT IN' in mysql. Is there an alternative
that would work?
select * from lib_asset_tbl where material_id '' and asset_id in (select
asset_id from lib_copy_tbl)
Help is appreciated.
Regards,
Harpreet Kaur
Software Developer
Crispin
I am currently running an online golf tournament on an NT server with an
Access database and asp pages. I have access to a Unix server that
supports asp script and mySQL database and I'd like to move my tour site
(for several reasons) but the SQL statements don't all work. The
following statement
I am currently running an online golf tournament on an NT server with an
Access database and asp pages. I have access to a Unix server that
supports asp script and mySQL database and I'd like to move my tour site
(for several reasons) but the SQL statements don't all work. The
following statement
Hi...
I want to output results based on the query from 3 tables ( described here )
TABLE 1
SUBID (SAME AS IN TABLE 2)
ID
FILE
DATE
DISCIPLINE (SAME AS IN TABLE 3)
TABLE 2
NAME
SUBID (SAME AS IN TABLE 1)
TABLE 3
NAME
EMAIL
-
From: Pawandeep Lamba [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 9:56 AM
To: [EMAIL PROTECTED]
Subject: QUERY HELP - IF THEN ELSE
Hi...
I want to output results based on the query from 3 tables ( described here )
TABLE 1
SUBID (SAME AS IN TABLE 2)
ID
Hello all,
I have 3 tables I need to join to extract certain data base on the acct_days in
the active table '6' days.
QUERY:
SELECT CONCAT(m.fname,' ',m.lname) AS name,
m.email,m.zip,p.paytype,p.event,p.paydate
FROM members m
LEFT JOIN payhistory p ON p.memid = m.memid
LEFT JOIN active a ON
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 1 November 2001 4:22 p.m.
To: [EMAIL PROTECTED]
Subject: Need query help
Hello all,
I have 3 tables I need to join to extract certain data base on the acct_days
in
the active table '6' days.
QUERY:
SELECT CONCAT
David,
First of all, please post to the list in the future. I'm not always
available to help with problems, and others may benefit from the
problem/solution.
I would change your query to the following:
SELECT DISTINCT a.addrdsp,a.listdate,a.solddate,a.lpricea,a.sprice
FROM archive a,
Hussain K.M. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 1:23 AM
To: [EMAIL PROTECTED]
Subject: Re: Query help...
Hi Mr. David,
I hope a bit of explanation for Steve Mayers' solution would help you.
The query by Mayers
select distinct a.username, a.ip from users a, users b where a.ip
: Thursday, October 25, 2001 9:58 AM
To: [EMAIL PROTECTED]
Subject: RE: Query help...
Quite a neat trick... but might there be problems with cross join
performance if the table is large? This is based on the assumption that
MySQL first creates the cross product, then culls out the rows
401 - 500 of 544 matches
Mail list logo
