Velen wrote:
Hi,
May be it's not the right forum i'm posting to.
I have a Mysql Query : Select a.code,b.description,
b.other_details,a.qty,a.price from xyz a, bcd b where a.code=b.code and
a.id='5' order by a.id
This is running fine but when using VB6 to display it in a Msflexgrid, it's a
- Original Message -
From: "Olav Mørkrid" <[EMAIL PROTECTED]>
To:
Sent: Friday, August 24, 2007 1:07 AM
Subject: where column
hello
does anyone know what is returned when you do a where column without
further parameters?
SELECT * FROM TABLE WHERE COLUMN;
for integer columns it se
- Original Message -
From: "Ben Liu" <[EMAIL PROTECTED]>
To:
Sent: Thursday, June 14, 2007 3:11 PM
Subject: need help with delete query
I'm trying to delete a subset of items in a table. The problem is, I don't
want to query for the subset first, store the results and then run a
se
- Original Message -
From: "Brent Baisley" <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 31, 2007 1:50 PM
Subject: Determining number of vowels in a string
I'm trying to do a select that will return the number of vowels/consonants
present in a string for each record. I thought a simpl
- Original Message -
From: "James Lockie" <[EMAIL PROTECTED]>
To: "MySQL Mailing List"
Sent: Friday, May 25, 2007 3:11 PM
Subject: do I need 2 selects?
Say I have x rows of 2 columns each.
For example, 2 rows: 'A 10:00pm' and 'A 11:00pm'.
I want to return one 'A' row with the late
