lest joint

  • Thread starter Thread starter JIM.H.
  • Start date Start date
J

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.
 
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.
Click to expand...

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.
 
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.
 
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.


.
Click to expand...
 
Back
Top