>I tried "Select * from a,b,c into cursor qcOutput", but i ended up with 27 records instead of 9. I know the extra records are partially because i have no join condition. What is the syntax to fix this?

What are the files structures and what do you want to end up with, that usually helps :-) maybe something like,

select * from a ;
full join b where a.id = b.id, ;
full join c where b.id = c.id ;
into table sqljoin.dbf