MySql Query

[jackie_patil]

Frnds,
I have one table name firm and Other Firmmanual.Both table contain field card_num and URL

I want to check crd_num where URL= null in table 'firm' and this crd_num is also present in table 'Firmmanual'

I want single query for above result and I am using MySQL 4.1.15 version

thank you.

[leatherback]

You asked the same question in databases. Don't cross post and learn how to ask a question please.