How do I combine 3 date columns from 3 tables in Foxpro sql?

Posted by Tass-man on Stack Overflow See other posts from Stack Overflow or by Tass-man
Published on 2010-04-30T06:37:53Z Indexed on 2010/04/30 6:47 UTC
Read the original article Hit count: 290

Filed under:

combine

|

foxpro

|

sql

I am writing a foxpro sql & need to combine three date columns from three different tables into a new date column. As an example if the three tables are A,B,& C and the date Columns are Adate, Bdate and Cdate, how do I combine them as distinct and separate dates into a column called TransDate and in the SQL? I would appreciate samples of the code if possible, as I am very new at this

© Stack Overflow or respective owner

Related posts about combine

Combine JavaScript and a Template Engine for Flexible Web Apps

as seen on Internet.com - Search for 'Internet.com'
Combine the power and simplicity of the TrimPath template engine with JavaScript and Ajax to develop next-generation web applications. >>> More
Combine JavaScript and a Template Engine for Flexible Web Apps

as seen on Internet.com - Search for 'Internet.com'
Combine the power and simplicity of the TrimPath template engine with JavaScript and Ajax to develop next-generation web applications. >>> More
Combine the Address & Search Bars in Firefox

as seen on How to geek - Search for 'How to geek'
The Search Bar in Firefox is very useful for finding additional information or images while browsing but the UI space it takes up can be frustrating at times. Now you can reclaim that UI space and still have access to all that searching goodness with the Foobar extension. Note: This is about the… >>> More
Combining Two CD-ROMs

as seen on Super User - Search for 'Super User'
Is there any way to combine two CDs? I have two game discs that I would like to put on one CD for easier distribution. These games are very very old and are only about 250 megs for their entire contents. Since they depend on their paths to run correctly, is there a way to write them to a disc in… >>> More
Connection two wireless ADSL routers to share IPs

as seen on Super User - Search for 'Super User'
I have two wireless ADSL routers sitting right next to each other, each with his own internet connection. I'd like to be able to connect to a computer that is connected to router A from a computer that is connected to router B, while keeping both routers internet connection individually. i.e. If… >>> More

Related posts about foxpro

foxpro to pdf and pdf to foxpro

as seen on Stack Overflow - Search for 'Stack Overflow'
how will i convert pdf database converted from foxpro back to foxpro >>> More
The dynamic Type in C# Simplifies COM Member Access from Visual FoxPro

as seen on West-Wind - Search for 'West-Wind'
I’ve written quite a bit about Visual FoxPro interoperating with .NET in the past both for ASP.NET interacting with Visual FoxPro COM objects as well as Visual FoxPro calling into .NET code via COM Interop. COM Interop with Visual FoxPro has a number of problems but one of them at least got a lot… >>> More
Does VBA have an equivalent of "Text To" from Visual FoxPro

as seen on Stack Overflow - Search for 'Stack Overflow'
Visual FoxPro supports syntax such as the following: Text To VariableName TEXTMERGE noshow select * from..... EndText This assigns the value of all text between "Text To" and "EndText" to the variable. It eliminates the need for multi line statements separateed by "+ ;" Does VBA have something… >>> More
How easy is it to convert an application from Visual Foxpro 6 to Visual Foxpro 9?

as seen on Stack Overflow - Search for 'Stack Overflow'
Are there any problems converting a Visual Foxpro 6 application to Visual Foxpro 9; or is this straight forward? Any gotchas that I should watch out for during the process? >>> More
Speaker at developer conferences and user group meetings

as seen on Get blogged by JoKi - Search for 'Get blogged by JoKi'
Catching up on a couple of sessions I did in the past. This article gives an overview of some of my activities. Mainly at the annual German Visual FoxPro Developer Conference also known as SQL-Server & ASP.NET Conference in Frankfurt. The below listed entries are excerpts from the original Conference… >>> More