Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL JOIN
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL JOIN
Miscellaneous
Thread ID:
00155673
Message ID:
00155673
Views:
59
Good morning all,

I have 2 tables I wish to join. They both have the same structure, but the conditions they were created with are different. Here's the statement I use:

select distinct exp_1, ass_sclass, Customer.cnt, TP.cnt ;
from customer full join TP ;
into table category

I get a syntax error when I try to run the program, but according to the help file, syntax is correct. Any thoughts??

TIA
Perry E. Chrzanowski
Programmer/Analyst
Saturn (Solutions) Inc.
Next
Reply
Map
View

Click here to load this message in the networking platform