General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
1. Yeah it does. Sorry I forgot to mention that.
2. What do you mean "nothing to join"?
SELECT * ;
FROM realtable LEFT OUTER JOIN dummycursor ON .T.
should work...
Michelle
>Michelle, DZ:
>
>It worked! with two things:
>
>1. the cursor contains dummy memo field needs one record
>2. no join in SQL SELECT, because there is nothing to join
>
>Here is my code, I added another field to the first cursor along with the dummy memo field.
>
>*******************************************
>CREATE CURSOR dummMemo ;
>(x1099 n(1), ;
>ckmemo m)
>
>INSERT INTO dummMemo (x1099, ckmemo);
> VALUES (0, "")
>
>SELECT RealInput.*, dummMemo.*;
> FROM RealInput, DummMemo into cursor MyResults
>********************************************
>
>Thought you might be interested!
>
>Have a Good Day, and Thanks!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only