General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Larry,
That's great. Just one more small clarification. Will there be any performance degradation using this way? Thanks
>I believe the following will work in both:
>SELECT field1, field2, mytable2.field3 FROM mytable1,mytable2 ;
> where mytable1.field1 = mytable2.field1
>UNION
>SELECT field1, field2, ' ' as field3 FROM mytable1 ;
> where mytable1.field1 not in (select mytable2.field1 from mytable2)
>You have to go back to the days before we had outer joins in VFP.
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