sql query ?

<i><b>Originally posted by : mike robb (aspfree@js-examples.com)</b></i><br /><br />I have 2 tables that I would like to query against both with one sql command.<br /><br />this is what i have tried and don't know what to try next (any ideas?)<br /><br />SELECT EX_KEYWORD.EX_ID AND EX_EXAMPLE.EX_ID FROM EX_KEYWORD AND EX_EXAMPLE WHERE EX_KEYWORD.KEYWORD LIKE '%document%' OR EX_EXAMPLE.TITLE LIKE '%document%'<br /><br />TIA! <br /><br /><br />---Mike Robb<br />http://www.js-examples.com

<i><b>Originally posted by : </b></i><br />try using a join. utilize sql view in MS access to get a feel for this.<br /><br /><br />------------<br />mike robb at 10/7/2000 2:56:23 PM<br /><br /><br />I have 2 tables that I would like to query against both with one sql command.<br /><br />this is what i have tried and don't know what to try next (any ideas?)<br /><br />SELECT EX_KEYWORD.EX_ID AND EX_EXAMPLE.EX_ID FROM EX_KEYWORD AND EX_EXAMPLE WHERE EX_KEYWORD.KEYWORD LIKE '%document%' OR EX_EXAMPLE.TITLE LIKE '%document%'<br /><br />TIA! <br /><br /><br />---Mike Robb<br />http://www.js-examples.com

<i><b>Originally posted by : Jeff Coon</b></i><br /> You might also want to try www.sqlcourse.com - a nice online tutorial, and you can play around doing selects on their DB in the page.<br /><br /> - Jeff<br /><br /><br />------------<br /> at 10/10/2000 8:22:12 AM<br /><br />try using a join. utilize sql view in MS access to get a feel for this.<br /><br /><br />------------<br />mike robb at 10/7/2000 2:56:23 PM<br /><br /><br />I have 2 tables that I would like to query against both with one sql command.<br /><br />this is what i have tried and don't know what to try next (any ideas?)<br /><br />SELECT EX_KEYWORD.EX_ID AND EX_EXAMPLE.EX_ID FROM EX_KEYWORD AND EX_EXAMPLE WHERE EX_KEYWORD.KEYWORD LIKE '%document%' OR EX_EXAMPLE.TITLE LIKE '%document%'<br /><br />TIA! <br /><br /><br />---Mike Robb<br />http://www.js-examples.com