Posted by carlospedr on 03/01/06 21:01

Try something like this:

SELECT COUNT(cisco.Products) FROM cisco INNER JOIN ciscocom
ON cisco.Products = ciscocom.Products
WHERE
cisco.Products='My_Value'

• Next in forum: Can I do this in SQL Analyzer or with a dts package?
• Prev in forum: How does one set read-uncommitted on the entire DB?
• Thread view: Re: getting the matching columns from two tables

[Reply to this message]