SiteExperts.com Logo Home | Community | Developer's Paradise
User Groups | Site Tools | Site Information | Search
 Main Menu
 Forums
SiteExperts.com Forums
All Discussions

SiteExperts Feedback
The Lounge
Dynamic HTML
Site Design/ Critiques
HTML and CSS
XML Technologies
The Wireless Internet
Internet Explorer
Microsoft .NET
The Server
Technical Support

Sponsored Links

User Groups : Forums : SiteExperts : The Server :

Previous DiscussionNext Discussion
 records with unique column data !

Hi ,

i want to select all the fields of a table with no duplicate firstName field !

table structure :

u_id , u_firstname , u_last name , u_address , u_tel

Started By vahid_reza on Mar 14, 2007 at 7:07:00 AM

5 Response(s) | Reply

View All Replies
brian on Mar 15, 2007 at 5:28:06 AM

It is...but in past experience I've found mysql (admittedly v4) to do strange things with what would be considered a standard sql statement (especially complex joins, unions and sub-queries). And MS access, well, it is good for what it is but again it does wierd things and anyone who is an experienced access programmer would probably tell you the same thing.


View All Replies

To respond to a discussion, you must first logon.

If you are not registered, please register yourself to become a member of the SiteExperts.community.

User Name
Password
Copyright 1997-2000 InsideDHTML.com, LLC. All rights reserved.