Use SELECT DISTINCT?
Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Carpet Broker, Dick Fey Sent: March-01-18 1:38 PM To: RBase Maillist Subject: [RBASE-L] - WHERE Clause ? I have a table that may have multiple lines from an order that are identical. I want to create a form with a where clause that will allow editing, but only one of each line that is unique. IE: Table holds: 180500 Red 180500 Red 180500 Red 180500 Blue 180500 Blue 180500 Blue My form using the where clause would only show: 18500 Red 18500 Blue Dick Fey Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
