Rhino
This is great it works a treat
Thanks
Regards
John Berman
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: 29 February 2004 13:40
To: [EMAIL PROTECTED]; 'Paul DuBois'
Cc: [EMAIL PROTECTED]
Subject: Re: Query Help
I hope you don't mind me butting in but your note
Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: 29 February 2004 13:40
To: [EMAIL PROTECTED]; 'Paul DuBois'
Cc: [EMAIL PROTECTED]
Subject: Re: Query Help
I hope you don't mind me butting in but your note was sent to the whole
group
The technique Paul is describing involves adding another
Hi
Using MySql 4.x and need some help with a query
There are two tables
Lists
Which holds list name +other stuff
Members
Which holds list name from above, email address + other stuff
I want to list all the lists and then which lists a member is associated
with.
Eg
List1 - Member
List2 -
At 23:09 + 2/28/04, John Berman wrote:
Hi
Using MySql 4.x and need some help with a query
There are two tables
Lists
Which holds list name +other stuff
Members
Which holds list name from above, email address + other stuff
I want to list all the lists and then which lists a member is
[mailto:[EMAIL PROTECTED]
Sent: 29 February 2004 00:08
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Query Help
At 23:09 + 2/28/04, John Berman wrote:
Hi
Using MySql 4.x and need some help with a query
There are two tables
Lists
Which holds list name +other stuff
Members
Which holds
At 0:32 + 2/29/04, John Berman wrote:
Paul
Err no, new area for me this
My two queries independently look like this
This give me all the lists some one is not a member of
SELECT lists_.Name FROM lists_ WHERE (((lists_.Name_) Not In (select
members_.List_ from members_ where
Paul
Well getting there, im now selecting the correct number of columns but get a
cant be distinct error ?
John B
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: 29 February 2004 00:47
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Query Help
At 0:32
PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Query Help
At 0:32 + 2/29/04, John Berman wrote:
Paul
Err no, new area for me this
My two queries independently look like this
This give me all the lists some one is not a member of
SELECT lists_.Name FROM lists_ WHERE (((lists_.Name_
At 2:45 + 2/29/04, John Berman wrote:
Got it working at last
SELECT lists_.DescShort_ FROM lists_ WHERE (((lists_.Name_) Not In (select
members_.List_ from members_ where members_.EmailAddr_ like (' em
' union SELECT lists_.DescShort_ FROM members_ INNER JOIN lists_ ON
members_.List_ =
Hello All,
I have a database with the following (simplified) structure:
[Products]
ProductID
ProductName
[PurchaseRecords]
ProductID
CustomerID
I need to find all of the rows in the table Products which do not have
at least one corresponding row in PurchaseRecords. How do I translate
Daniel,
I have a database with the following (simplified) structure:
[Products]
ProductID
ProductName
[PurchaseRecords]
ProductID
CustomerID
I need to find all of the rows in the table Products which do not have
at least one corresponding row in PurchaseRecords. How do I translate
this
Good afternoon,
How can I take the 3 results below add them together then divide by
131.77?
Can it all be done in one SQL statement?
Thanks in advance.
mysql describe ads;
+---+---+--+-+++
What about
SELECT (SUM( ads.col * 1.91) * ads.depth ) ) / 131.77
FROM ads
WHERE date = '2004-02-26'
AND editionID = '13'
AND ads.page = '16'
Original Message
On 2/25/04, 4:19:12 PM, Rogers, Dennis [EMAIL PROTECTED] wrote
regarding Query help - add results then divide by :
Good
: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; Hines, David
Subject: Re: Query help - add results then divide by
What about
SELECT (SUM( ads.col * 1.91) * ads.depth ) ) / 131.77
FROM ads
WHERE date = '2004-02-26'
AND editionID = '13'
AND ads.page = '16'
Original Message
On 2/25/04, 4:19:12 PM
I think that you can just do this:
select sum(ads.col)*1.191*sum(ads.depth)/131.77 where date ='2004-02-26'
AND editionID = '13' AND ads.page = '16';
because of the disttributive property of multiplication.
(2 * 1.191) +(6*1.91) +(4*1.91)/131.77 = 12 *1.91/131.77 =
(12*1.91)/131.77 =
Rogers, Dennis wrote:
Good afternoon,
How can I take the 3 results below add them together then divide by
131.77?
Can it all be done in one SQL statement?
Thanks in advance.
mysql describe ads;
+---+---+--+-+++
This is probably tediously basic for all you super whiz MySQL people but help me out
if you can.
I have 2 tables in my database (there will be more)
table_Applics table_keywords
I want to select columns of information from table_applics based on the ID results
from table_keywords.
something
This is probably tediously basic for all you super whiz
MySQL people
but help me out if you can.
I have 2 tables in my database (there will be more)
table_Applics table_keywords
I want to select columns of information from
table_applics based on the
ID results from table_keywords.
Hi,
I've some data out of a legacy application which has a list of names and
mailing addresses for contacts. The legacy data is from a DG database.
Every few weeks my sql database will be repopulated. There are four
varchar(30) fields describing names and addresses (name1,add1,add2,
Hi,
Background: I run a prediction league for soccer
competitions. For every game, I want to show how many
predictions were submitted per scoreline, ie.
10% said 1-0
20% said 0-1
30% said 2-3
etc.
My prediction table has a predictionA and predicionB
column with the submitted scores.
Currently
- Original Message -
From: Riaan Oberholzer [EMAIL PROTECTED]
2-0, 2-1, 2-2, 2-3
1-0, 1-1, 1-2, 1-3
0-0, 0-1, 0-2, 0-3
SELECT CONCAT(predictionA, '-', predictionB) AS score,
COUNT(CONCAT(predictionA, '-', predictionB)) AS count
FROM table
WHERE CONCAT(predictionA, '-', predictionB)
Hi
I have a table called sections with the following structure:
+---++--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---++--+-+-++
| secid | int(11)|
No. With the method you're using (storing the parent id with each record)
you have to use a recursive series of queries to show the subtree levels.
Take a look at this article--especially the second and third pages about the
modified preorder tree traversal and nested sets. There are many
?
or simply:
UPDATE RemoteStation SET company=LEFT(ID, 4); ?
gerald_clark [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
How about:
update RemoteStation set company=substring(ID,1,1);
Jeff McKeon wrote:
Damn fat fingers and MS Outlook. I sent the Query Help message
I have two tables, customer table and a company table
The customer table has an ID field that is 8 characters long. The first
4 characters are the company code.
We just added a company table that has an id field that contains that
companies id code. We also added a field to the customer table
Damn fat fingers and MS Outlook. I sent the Query Help message before
I was finishes typing. Sorry...
I have two tables, customer table and a company table
The customer table has an ID field that is 8 characters long. The first
4 characters are the company code.
We just added a company table
How about:
update RemoteStation set company=substring(ID,1,1);
Jeff McKeon wrote:
Damn fat fingers and MS Outlook. I sent the Query Help message before
I was finishes typing. Sorry...
I have two tables, customer table and a company table
The customer table has an ID field that is 8 characters
Outlook. I sent the Query Help message before
I was finishes typing. Sorry...
I have two tables, customer table and a company table
The customer table has an ID field that is 8 characters long. The first
4 characters are the company code.
We just added a company table that has an id field
:
update RemoteStation set company=substring(ID,1,1);
Jeff McKeon wrote:
Damn fat fingers and MS Outlook. I sent the Query Help message before
I was finishes typing. Sorry...
I have two tables, customer table and a company table
The customer table has an ID field that is 8 characters long
On 2 Dec 2003 at 7:20, Greg Jones wrote:
snip
select l.ltsysid,l.lientraknum, c.name from lientrak as l, customer as c
where l.custsysid=c.custsysid
and l.ltsysid in (select l2.ltsysid from lientrak as l2 where l2.lientraknum
like '2003-%')
snip
Hi greg
Yopur problem is that you
I am in the process of migrating a database and some code from an MSSQL
database and am running into a little problem with some queries. Would
appreciate any help anyone could offer.
I currently have this query which runs fine when using either MSSQL or
Access. However, when I run it against
Access. However, when I run it against MySQL I get an error.
select l.ltsysid,l.lientraknum, c.name from lientrak as l, customer as c
where l.custsysid=c.custsysid
and l.ltsysid in (select l2.ltsysid from lientrak as l2 where
l2.lientraknum
like '2003-%')
Sub queries are not going to be
- Original Message -
From: Chris Boget [EMAIL PROTECTED]
To: Greg Jones [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 8:32 AM
Subject: Re: Query Help
Access. However, when I run it against MySQL I get an error.
select l.ltsysid,l.lientraknum, c.name from
I have a two tables.
One has catagories, the other has articles.
I need a query that deletes catagories only
if not articles have that catagory.
Table faqcat(cat int not null auto_increment, name varchar(20))
Table article(aid in not null auto_increment, cat int, .)
Want to :
delete from
it works
- Original Message -
From: Darryl Hoar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 11:10 AM
Subject: Query help
I have a two tables.
One has catagories, the other has articles.
I need a query that deletes catagories only
if not articles have
.
Regards,
Adam
-Original Message-
From: Darryl Hoar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 11:11 AM
To: [EMAIL PROTECTED]
Subject: Query help
I have a two tables.
One has catagories, the other has articles.
I need a query that deletes catagories only
if not articles have
Hi,
I have this table where the columns and rows are organized like this:
+--+--+
| a| b|
+--+--+
|1 |1 |
|2 |1 |
|2 |2 |
|2 |3 |
|2 |4 |
|3 |1 |
|3 |2 |
+--+--+
I want to run a select that gives me one row
Hi,
I forgot to mention that the table contains more information, it has
more columns than just a and b. These extra columns contains the actual
information that I'm looking for.
I.e. the mentioned table could be looking like this:
+--+--+--+--+-+---
| a| b|
I have added data into MySQL server 4.0.15
INSERT INTO userdata (userid, password)
VALUES ('user', AES_ENCRYPT (user,password)
I'm having trouble doing the decrypt
SELECT userid, password (AES_DECRYPT)
FROM userdata blah blah blah
At 1:08 PM -0600 9/19/03, Stout, Jeff wrote:
I have added data into MySQL server 4.0.15
INSERT INTO userdata (userid, password)
VALUES ('user', AES_ENCRYPT (user,password)
I'm having trouble doing the decrypt
SELECT userid, password (AES_DECRYPT)
FROM userdata
Can anybody help me sort my results in the correct way.
My Table description is:
+--+---+--+-+-++
| Field| Type | Null | Key | Default | Extra |
+--+---+--+-+-++
| id
Not sure I understand what you need?
Can you create a dummy output table of what you would like your result
to look like?
At first glance, from reading your question, it sounds like you simply
want this:
select * from ppc_keywords where keywords like %job% [group by
keywords] order by bid;
I think the most difficult ( if not impossible with just using mysql
query) is the part where you apply your logic as to the most relevant
keyword.
You need to be able to have a mechanism of telling the query which
keyword is the most relevant, ie, human logic says, the one that matches
the search
El vie, 29-08-2003 a las 22:05, Daniel Clark escribió:
select value from tableName where date in (select max(date) from
tableName where id = 4);
But, it doesn't work with mysql 4.0.
Any ideas? Does anybody had this problem before?
What about:
SELECT value, date
FROM tablename
* Boris Villazon
El vie, 29-08-2003 a las 22:05, Daniel Clark escribió:
select value from tableName where date in (select max(date)
from tableName where id = 4);
But, it doesn't work with mysql 4.0.
Any ideas? Does anybody had this problem before?
What about:
SELECT
When I execute the following query I get duplicate product_id's as shown
below:
SELECT * FROM product, product_category_xref, category WHERE
product_parent_id=''
AND product.product_id=product_category_xref.product_id
AND category.category_id=product_category_xref.category_id
AND
When I execute the following query I get duplicate
product_id's as shown
below:
SELECT * FROM product, product_category_xref, category WHERE
product_parent_id=''
AND product.product_id=product_category_xref.product_id
AND category.category_id=product_category_xref.category_id
AND
Hi
I have a little problem with my sql skills.
I have a table with the following fields:
id (int) | value (varchar) | date (date)
I need to show for a given id the value of the oldest date.
Normally, I'd do something like this:
select value from tableName where date in (select max(date)
select value from tableName where date in (select max(date) from
tableName where id = 4);
But, it doesn't work with mysql 4.0.
Any ideas? Does anybody had this problem before?
What about:
SELECT value, date
FROM tablename
WHERE id = 4
ORDER BY date ASC
Just pick the first row.
--
I have a table that records connections from customers to our server.
When there is a software problem with our customer's that have older
versions of our software, it will dial our server constantly over and
over again.
I want to be able to detect this by having a query that does something
like
HOUR))
Group by cust.id
HAVING count(cust.id) 5;
-Original Message-
From: Jeff McKeon [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 11:44 AM
To: [EMAIL PROTECTED]
Subject: Query Help
I have a table that records connections from customers to our
server. When
Thanks, that did it!
Jeff
-Original Message-
From: Kevin Fries [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 3:05 PM
To: Jeff McKeon; [EMAIL PROTECTED]
Subject: RE: Query Help
So you want to group by the customer, but only show those
gorupings with a count 5
Hi Ivan,
depending on mark's needs (orginal poster of the question), you might be
right. So far I have not so much experience with PHP.
Best regards
Nils Valentin
Tokyo/Japan
2003 7 27 15:43Ivan Cukic :
Nils How about LIKE \$%searchdata%\ ?
The % sign should be in front of $
LIKE
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
To: Obantec Support [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, July 27, 2003 2:05 AM
Subject: Re: A little SQL query help
Hi Mark,
2003 7 27 06:09Obantec Support :
Hi
I have a database supplied to me
: Sunday, July 27, 2003 2:05 AM
Subject: Re: A little SQL query help
Hi Mark,
2003 7 27 06:09Obantec Support :
Hi
I have a database supplied to me that was excel but now uploaded to
mysql.
(the data is out of my hands.)
i need to search for 1 of 2 categories against 3 fields
Hi
I have a database supplied to me that was excel but now uploaded to mysql.
(the data is out of my hands.)
i need to search for 1 of 2 categories against 3 fields with user inputted
data.
example Categories=Lessor , searchtype = BusinessCity searchdata = (user
input)
$sql = SELECT * FROM
Hi Mark,
2003 7 27 06:09Obantec Support :
Hi
I have a database supplied to me that was excel but now uploaded to mysql.
(the data is out of my hands.)
i need to search for 1 of 2 categories against 3 fields with user inputted
data.
example Categories=Lessor , searchtype = BusinessCity
Hi I'm looking to create a query that will look through my previous orders
and create a table of what items have sold with what products.
My current table that holds the order details is set up like this.
orderID, productID, quantity.
Any suggestions would be appreceiated.
Thanks,
Chuck
--
At 11:02 -0500 7/24/03, Chuck Barnett wrote:
Hi I'm looking to create a query that will look through my previous orders
and create a table of what items have sold with what products.
My current table that holds the order details is set up like this.
orderID, productID, quantity.
I see an order ID
[snip]
Hi I'm looking to create a query that will look through my previous
orders
and create a table of what items have sold with what products.
My current table that holds the order details is set up like this.
orderID, productID, quantity.
Any suggestions would be appreceiated.
[/snip]
You
* Chuck Barnett
Hi I'm looking to create a query that will look through my previous orders
and create a table of what items have sold with what products.
My current table that holds the order details is set up like this.
orderID, productID, quantity.
Any suggestions would be appreceiated.
Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 13, 2003 7:29 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: query help!!!
Hi...
I have a questiona problem actually!!!
I'm trying to figure out how to determine the descendents of a given
child would be. The table
Hi...
I have a questiona problem actually!!!
I'm trying to figure out how to determine the descendents of a given child
would be. The table defs are...:
CREATE TABLE ItemTbl
(
id int(5) NOT NULL auto_increment,
itemnamevarchar(25) NOT NULL default '',
generate.
- Original Message -
From: bruce [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 2:29 AM
Subject: query help!!!
Hi...
I have a questiona problem actually!!!
I'm trying to figure out how to determine the descendents of a given
Hi,
I'm building a planning system for a newspaper. Article ideas are defined
as articles with no deadline, no publication date or no reporter assigned.
I wan't to show all entries from table un_article that matches those three
criterias.
I have three tables:
CREATE TABLE un_article
(
a_id
anders thoresson schrieb:
I'm building a planning system for a newspaper. Article ideas are
defined as articles with no deadline, no publication date or no reporter
assigned. I wan't to show all entries from table un_article that matches
those three criterias.
I have three tables:
CREATE
otherguy (Cameron Wilhelm ) wrote:
Well, keep in mind that although SQL can do a lot in a single
statement, it can't always do *everything* required for a business
function in one statement.
As I'm painfully aware of, but was hopeful about.
Your hopes were sensible -- I believe that some SQL
: Terry Vanstory [EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 12:05 AM
Subject: RE: Advanced Query Help (My brain hurts!)
would u have an example of how to use union then ? like on the second
select
i need to reutn a heap of rows from a field from the first select
-Original Message
can just append the two results by using
UNION.
Good Luck!
Dennis
- Original Message -
From: otherguy [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Cc: Terry Vanstory [EMAIL PROTECTED]
Sent: Friday, June 27, 2003 8:50 PM
Subject: Advanced Query Help (My brain hurts!)
Hey guys, I'm
otherguy wrote:
That gets me halfway there
Does it? In your original question, you'd indicated that you only
wanted zips where *both* criteria were met -- enough CIRGs and enough
CILTs. By using a UNION, you'll be getting zips where *either* is met.
Bruce Feist
--
MySQL General Mailing
: Advanced Query Help (My brain hurts!)
Thank you!
That gets me halfway there, and not to my surprise, it's not even that
hard! I should've known that it wouldn't be.
So the other part that I truly have no idea how to do the following:
UPDATE this_other_table
SET satus =
WHERE
- Original Message -
From: Bruce Feist [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 6:28 PM
Subject: Re: Advanced Query Help (My brain hurts!)
otherguy wrote:
That gets me halfway there
Does it?
Yes, it does.
In your original question, you'd
On Saturday, June 28, 2003, at 03:43 PM, MyLists wrote:
otherguy wrote:
That gets me halfway there
Does it?
Yes, it does.
No, I don't think it does, upon further consideration and testing... I
thought it did b/c I read, and misinterpreted the UNION
documentation
In your original
On Saturday, June 28, 2003, at 07:15 PM, Bruce Feist wrote:
otherguy wrote:
On Saturday, June 28, 2003, at 03:43 PM, MyLists wrote:
That gets me halfway there
BF: Does it?
No, I don't think it does, upon further consideration and testing...
I thought it did b/c I read, and
Hey guys, I'm about to dump a doozy on your collective knowledge and
goodwill, and hope for some help or some pointers. I'm not great with
advanced SQL, and I've gotten as far as my brain and the resources I've
been using will allow me to get for the time being.
I need help with two things:
PROTECTED]
Sent: Friday, June 27, 2003 8:50 PM
Subject: Advanced Query Help (My brain hurts!)
Hey guys, I'm about to dump a doozy on your collective knowledge and
goodwill, and hope for some help or some pointers. I'm not great with
advanced SQL, and I've gotten as far as my brain and the resources
Subject: Re: Advanced Query Help (My brain hurts!)
How about a UNION statement? If the two queries are independently returning
what you need, then you can just append the two results by using UNION.
Good Luck!
Dennis
- Original Message -
From: otherguy [EMAIL PROTECTED]
To: MySQL List
Hi,
I am hoping you can help me please.
The following query, while valid, returns me an Empty set.
--
SELECT plan, cardNr, crdholdersName, cardType, cardExpDate,
strAddr, townCity, stateProvince,
Hi all,
I am fairly new to SQL and this is a really complex query for me.
Here is the setup. 3 tables. tbl_personnel, tbl_personnel_dras, tbl_dra
each person in the tbl_personnel table can have 0 - 3 records in the
tbl_personnel_dras table. The tbl_personnel_dras table is just the
person_id
Charles Kline wrote:
I am fairly new to SQL and this is a really complex query for me.
Possibly more complex than necessary. Must you have a separate column
for each of the areas? If you don't mind having them all in a single
column, the query becomes simple and efficient:
SELECT p.fname,
Hi All MySQL guru's
I have a query that I need some help with. I have put into operation a setup
that needs to be chnaged and could do with a little help before the Db get any
bigger. It's only a small MySQL DB at the moment but will grow so I need to get
this right now before it gets bigger.
--- Andrew [EMAIL PROTECTED] wrote:
Hi All MySQL guru's
I have a query that I need some help with. I have put into operation a setup
that needs to be chnaged and could do with a little help before the Db get
any
bigger. It's only a small MySQL DB at the moment but will grow so I need to
Very informative MySQL list. Good Job People!
Query Question..
Two tables
1. Clients
ClientID (Primary Key, Unsigned int , Auto_Increment)
Vehicle typeChar(200)
Vehicle Color CHAR(200)
2. Service
ServiceID (Primary Key, Unsigned int ,
* [EMAIL PROTECTED]
Two tables
1. Clients
ClientID (Primary Key, Unsigned int , Auto_Increment)
Vehicle typeChar(200)
Vehicle Color CHAR(200)
2. Service
ServiceID (Primary Key, Unsigned int , Auto_Increment)
ClientID
Hi Bruce,
Thanks for your reply. I just got the time to take a look at it, and
it makes sense. However, for the first test:
SELECT distinct t.name
FROM Teacher t
INNER JOIN (TeacherClass tc2 INNER JOIN Class c2 ON tc2.classid =
c2.id AND c2.name = 'English') ON t.teacherid =
Ben Balbo wrote:
Seems MySQL doesn't much like having nested joins in joins...
Oops! Sorry about that. (Curse me for a MySQL novice! g)
However, your principles led me to my result. As the search page will
pass the class ids in anyway, I don't need to read these from the
table. I.E. I pass
Apologies if you now get this three times now, but I haven't
received any copies through the mailing list yet, and the first 2 were
sent 3 and 4 hours ago.
I know email can go walkies for a few hours, but I've not been
experiencing any other mail problems, either personally or in
receiving MySQL
Hi all,
I've been trying to wrap my head round this problem for a few days
now, and have plenty of pieces of scrap paper with lines and arrows
and numbers to prove it.
Anyway, here's the scenario:
I have a table of teachers, and a table of classes. Any teacher can
have taught any class, and any
Hi all,
I've been trying to wrap my head round this problem for a few days
now, and have plenty of pieces of scrap paper with lines and arrows
and numbers to prove it.
Anyway, here's the scenario:
I have a table of teachers, and a table of classes. Any teacher can
have taught any class, and any
Ben Balbo wrote:
Teacher (id, name, ...)
TeacherClass (teacherid, classid, timestamp)
Class (id, name, ...)
Now, what I'd really like to do it find all teachers who, for example,
taught Engligh and Math, but not Biology,
Here's a general, recursive, untested solution for you to play with.
We
On Thursday 20 February 2003 02:17 pm, Ajay Patel wrote:
I have a host table where I save the platform model. The platform model
can be saved in various ways. For example,
Sun Enterprise 250 (2 x UltraSPARC 164MHz)
Sun Enterprise 250 (2 x UltraSPARC-II 400MHz)
Sun Enterprise 250 (2 x
I have a host table where I save the platform model. The platform model
can be saved in various ways. For example,
Sun Enterprise 250 (2 x UltraSPARC 164MHz)
Sun Enterprise 250 (2 x UltraSPARC-II 400MHz)
Sun Enterprise 250 (2 x UltraSPARC-II 450MHz)
Sun 250
etc. I can get the count by:
select
I think you can't
If you want this why is this table structure? Details shold be as columns
nos as records in separate table - just to lose time ?
On Tue, 11 Feb 2003 13:13:31 +, Jeff Snoxell [EMAIL PROTECTED]
wrote:
Hi,
How can I write a MySQL query to grab single lines of the form:
Hi,
How can I write a MySQL query to grab single lines of the form:
ColumnNames: EnquiryID, Name, Address, Detail1, Detail2, Detail3, Detail4
From two joined tables:
Tbl1: Enquiries
--
ID
Name
Address
Etc
Tb12: Details
ID
EnquiryID
Detail
Etc
You have one column detail - What do you mean by detail1, detail2 and so?
=
On Tue, 11 Feb 2003 13:13:31 +, Jeff Snoxell [EMAIL PROTECTED]
wrote:
Hi,
How can I write a MySQL query to grab single lines of the form:
Hi,
How can I write a MySQL query to grab single lines of the form:
ColumnNames: EnquiryID, Name, Address, Detail1, Detail2, Detail3, Detail4
From two joined tables:
Tbl1: Enquiries
--
ID
Name
Address
Etc
Tb12: Details
ID
EnquiryID
Detail
Etc
Subject: Problem with a query - help!!?
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
PROTECTED]
Sent: Monday, February 03, 2003 15:46
Subject: Problem with a query - help!!?
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
= ''
HTH
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: David Phipps [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, February 03, 2003 15:46
Subject: Problem with a query - help!!?
Hi,
I am new to this list so I apologise
Hi,
I think the problem is that your assuming that journoNatOpt.journoid is
'' (empty) when journoDetails.journoid has no entry in journoNatOpt.
But that's not true, the value is NULL.
So, try replacing
AND journoNatOpt.journoid = ''
with
AND journoNatOpt.journoid IS NULL
On Mon,
301 - 400 of 544 matches
Mail list logo