Insert into table2 (column2) select distinct column1 from table1 Dan Goldberg
From: [email protected] [mailto:[email protected]] On Behalf Of Richardson, Jeff Sent: Thursday, October 20, 2016 1:34 PM To: [email protected] Subject: [RBASE-L] - Load Syntax Hello. I want to load the distinct values from Column1 of Table1 into a Column2 of Table2. I’ve done this before, so I know there is a way, but the syntax is escaping me at the moment. Can anyone help? Thanks! Jeff Richardson | Project Manager, Asset Verification Services (AVS) DMA – DuCharme, McMillen & Associates, Inc. | 828 S Harrison Street Suite 650, Fort Wayne, IN 46802 Cell: 724-366-1724 Connect: [email protected]<mailto:[email protected]> | Website<http://www.dmainc.com/> | LinkedIn<https://www.linkedin.com/company/ducharme-mcmillen-&-associates> | Twitter<https://twitter.com/DMATAX> | Facebook<https://www.facebook.com/DMAtaxservices> ___________________________________________________________ ATTENTION: This message and all attachments are PRIVATE, and may contain information that is CONFIDENTIAL and PRIVILEGED. If you have received this message in error, please notify the sender by reply e-mail and delete the message immediately. ATTENTION: This message and all attachments are PRIVATE, and may contain information that is CONFIDENTIAL and PRIVILEGED. If you have received this message in error, please notify the sender by reply e-mail and delete the message immediately. Disclaimer The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful. This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more Click Here<http://www.mimecast.com/products/>. -- 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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- 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.

