problem retreiving data (mysql++1.7.17)

2004-11-08 Thread David Kinyanjui
Hello; I have a mysql++ question... I'm not sure if this is right list to post to. Well, I just upgraded mysql++ from version 1.7.9 to 1.7.17. Now, my problem is I don't seem to be getting the collect data from a table. I have an order table with the following cols: LastName, FirstName, OrderDate

SELECT Optimization (speeding up a SELECT)

2003-12-24 Thread David Kinyanjui
Hello there; I have the following mysql Select: SELECT ndc, ln, fdb.rndc.gcn_seqno, rt FROM fdb.rndc INNER JOIN fdb.rgcnseq on fdb.rgcnseq.gcn_seqno=fdb.rndc.gcn_seqno LEFT JOIN fdb.rrouted ON fdb.rrouted.gcrt=fdb.rgcnseq.gcrt WHERE ln LIKE '%%%' GROUP BY gcn_seqno, ln ORDER BY rndc.ln LIMIT 50;