Hi Guys,
I have a delima... not really a foxpro question, but I am using access, but I am using SQL to do it. Here is the situation. I have 3 tables, a, b, c. They all contains same fields, let say, I want to do a query within all three tables, whats the correct approach? To create a view with all three tables? or? Is there sample codes I can get off someone please?
Thanx
Tom