>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

I don't know about access but in VFP you would use UNION to combine 3 selects into one.