Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query troubles.
Message
From
06/06/2001 12:45:25
Alex Feldstein
Florida, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Query troubles.
Miscellaneous
Thread ID:
00515817
Message ID:
00515886
Views:
18
Interesting idea on the HAVING w/o a GROUP BY. This is for VFP only but still no go. See my answer to Vlad.

>>>>>>>>>>>>>>>>>
>You may want to try something like this:
>
>
>select table1.key, table2.key;
>from table1
>     left outer join table2 on table1.key=table2.key ;
><b>having isnull(table1.key)</b>
>
>
>Watch out, I think the fact that HAVING is working in a SQL statement without GROUP BY is a bug in VFP. A statement like this will fail in SQL Server or Oracle.
>>>>>>>>>>>>>>>>>


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform