Delete Multipal Record Query ?

Question

I am try to this things,

 When i delete state also delete this state city delete.

my query

DELETE FROM ab
FROM         City AS ab INNER JOIN
                      State AS b ON ab.state_id = b.state_id CROSS JOIN
                      ab
WHERE     (ab.state_id =
                          (SELECT     state_id
                            FROM          State
                            WHERE      (state_name = @state_name)))

        My state table
        city_id,city_name

11	Rajasthan
12	Gujarat
13	Maharastra

My city table

city_id,city_name,state_id

12	Ahmedabad	12
14	Borivali	13
16	Surat	12
19	Udaypur	11
20	Mumbai	13
21	Pune	10
22	Vadodara	12
25	Anand	12

Error Message : Invalid object name 'ab'