question is: Does any one have any recommendations of a process I
could use to do this effectively ?
Many Thanks in advance
Traiano Welcome
---
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
use distinct() instead.
- Original Message -
From: AVDHUT SHEDGE [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 08, 2001 3:00 PM
Subject: Regarding SQL query with Unique
We want to get the Unique value from a table.
can we use the following query:
select
it means it allow multiple records have same value in a table. i.e. It allow
index to contain duplicates.
it really is not a key. it is a kind of index instead.
if you have a table using a primary key say table_a, try to use SHOW INDEX
FROM table_a, then SHOW INDEX FROM ACCOUNTING. you can see
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
here says that mysql does not support sub-selects thus you see errors.
also here shows you that how to rewrite sub-selects.
- Original Message -
From: "Nicolas Villatte" [EMAIL PROTECTED]
To: "Mysql (E-mail)" [EMAIL PROTECTED]