Hi All
I have what I hope is a very simple question;
Just started experimenting with joins, so I tried a very basic test and got
a fail that I don't understand. It appears that SA is creating bad SQL, but
I'm sure it's something I'm missing.. Here's what I did;
I have two tables. products
Warwick Prince wrote:
Hi All
I have what I hope is a very simple question;
Just started experimenting with joins, so I tried a very basic test
and got a fail that I don't understand. It appears that SA is
creating bad SQL, but I'm sure it's something I'm missing.. Here's
what I did;
Hi Simon
Thanks for that - I knew it was something wrong with the approach but simply
could not pick it!Back to the test bench for another go :-)
Cheers
Warwick
P.S. OK - I have to ask - when and how (why?) do I do the .join on the
query? ;-)
On 5 October 2010 19:41, King Simon-NFHD78
Warwick Prince wrote:
Hi Simon
Thanks for that - I knew it was something wrong with the approach but
simply could not pick it!Back to the test bench for another go :-)
Cheers
Warwick
P.S. OK - I have to ask - when and how (why?) do I do the .join on
the query? ;-)
In SQL,
Hi Simon
Thanks for your help. It's amazing what a tiny hint in the right direction
can do.. Between these emails, I've made a proof on concept, and am now
implementing the code in the real app. So easy when I'm not blocked by a
warped vision of what I'm doing.
Funny, looking back at the