SQL command with "INNER JOIN" in .net

[soldieryap]

i tried a sql command in MS Access and it work properly but when i tried to put it in commandtext in vb.net (of course modified some to suit vb code), it had problems. how's that happened?? is that vb.net doesn't support it? thanks for answer me.

example : SELECT bread.[bread id], bread.Name, factory.ID, factory.name FROM bread INNER JOIN factory ON bread.[bread id] = factory.[bread id]

 

[Zarcom]

I don't claim to know much about SQL but wouldn't the following work? I have never been a fan of the INNER JOIN just seems rather complicated when this works just as well.

SELECT bread.[bread id], bread.Name, factory.ID, factory.name
FROM bread, factory
WHERE bread.[bread id] = factory.[bread id]


Not sure that this is really answering your question though. What is commandtext? Is it a DB command object? That'l do donkey, that'l do

 

[MapMan]

Hi soldieryap,

The syntax of your SQL statement is valid. So, I'm wondering if it's something else. What is the error you're getting?

Regards, MapMan

Assume nothing, question everything, be explicit not implicit, and you'll always be covered.