How do I combine 3 date columns from 3 tables in Foxpro sql?
- by Tass-man
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