lest joint

[JIM.H.]

Hello
I have left joint on the links, but it seems it is not
working as it should. I do not see all the records fro
first table, instead I see empty rows.
Thanks,
Jim.

 

[John Vinson]

Hello
I have left joint on the links, but it seems it is not
working as it should. I do not see all the records fro
first table, instead I see empty rows.
Thanks,
Jim.

Jim,

Please give us a little help here. You know what your tables are, and
how your queries are constructed. We don't.

Please describe your tables, and perhaps post the SQL view of the
query that's returning no data.

 

[Guest]

SELECT mytable.cmt, mytable.col, mytable.cat, mytable.mf,
mytable.mis, mytable.name, mytable.cost, mytable.sto INTO
mytable3
FROM mytable2 LEFT JOIN mytable ON (mytable2.loc =
mytable.cat) AND (mytable2.sk = mytable.sto)
ORDER BY mytable.sto;
Thanks,
Jim.

 

[Guest]

John,
Thanks I think I found the problem.
bye
Jim.

-----Original Message-----


Jim,

Please give us a little help here. You know what your tables are, and
how your queries are constructed. We don't.

Please describe your tables, and perhaps post the SQL view of the
query that's returning no data.


.